Skip to Content
avatar image
Former Member

SAP BPC ALLOCATION SCRIPT

Hi Experts,

I need help in allocating the cost from Total Pool Cost ( POOL_COST) to Different Business units Base Members ( ALL_BU_DIV). I have currently executed the following script and found this is not working. Could anyone help.

*XDIM_MEMBERSET COST_ELEMET = BAS(POOL_COST) *XDIM_MEMBERSET BU_DIV = BAS(ALL_BU_DIV) *XDIM_MEMBERSET CATEGORY = Actual *XDIM_MEMBERSET RPTCURRENCY = USD *RUNALLOCATION *FACTOR = USING/TOTAL *DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=<<<; USING=ALLOC_KEY_SQM; TOTAL=<<<; *DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<; TOTAL=<<<; *DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<; *ENDALLOCATION

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi Joji,

    On which version of BPC are you working??? 10 or 10.1?? MS or NW??/

    If NW then correct tag should be "SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver".

    P.S Please post your script on readable format!

    JP

  • Former Member Former Member

    Hi JP Thank you for your reply

    I was not able to view SAP Business Objects Planning and Consolidation, version for SAP Net Weaver". in the Tag list while I posted.

    I am working in 10.0.

    Script posting in readable format:-

    *XDIM_MEMBERSET COST_ELEMET = BAS(POOL_COST)

    *XDIM_MEMBERSET BU_DIV = BAS(ALL_BU_DIV)

    *XDIM_MEMBERSET CATEGORY = Actual

    *XDIM_MEMBERSET RPTCURRENCY = USD

    *RUNALLOCATION

    *FACTOR = USING/TOTAL

    *DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=<<<; USING=ALLOC_KEY_SQM; TOTAL=<<<;

    *DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<; TOTAL=<<<;

    *DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<;

    *ENDALLOCATION

  • Former Member Former Member

    Try to edit your primary tag.....

    What is ALLOC_KEY_SQM??? Can you explain your logic? Where is cost???

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 11, 2017 at 09:25 AM

    Hi JP&

    I have an amount determined in the POOL COST which is captured in the input form . Based on the total amount this needs to be distributed among business units . I have attached a file with the screen shot. This is the logic. Sorry I am new to this.example.jpg

    ,

    Hi JP&

    I have an input form where in the total cost known as POOL COST is entered. Say the POOL COST is 1000. This amount has to be distributed by business to different business units based on some proportions. This is the logic I am trying to achieve.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      So as per your screenshot 149054 amount is POOL COST and the proportions given 0.002 are ALLOC_KEY_SQM????

  • avatar image
    Former Member
    Jan 11, 2017 at 09:37 AM

    Yes for time being lets take out ALLOC_KEY_SQM and call it only proportions.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 09:48 AM

    *XDIM_MEMBERSET CATEGORY = Actual

    *RUNALLOCATION

    *FACTOR = USING

    *DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=<<<; USING=PROPORTIONS;

    *DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<;

    *DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<;

    *ENDALLOCATION

    Just try this.....I dont have a system currently so cant test.....

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 09:49 AM

    Sure I will try

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 10:13 AM

    I tried in BW system UJKT , but there us no Output while in run Simulate.

    I am attaching the requirement in the screen shot example.jpg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Please check the data cross sections properly when you are saving the data in the input form....the same has to be used in the script! When you save cost what is the business unit you use????

  • avatar image
    Former Member
    Jan 11, 2017 at 12:34 PM

    Hi JP&

    I have attached two files , one which is the actual requirement and other which shows the dimensions and models.

    example.jpg

    example-1.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 12:45 PM

    *XDIM_MEMBERSET CATEGORY = Actual

    *RUNALLOCATION

    *FACTOR = USING

    *DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=<<<; USING=PROPORTIONS;

    *DIM BU_DIV WHAT=NO_BU_DIV; WHERE=BAS(TOTAL_BU_DIV); USING=<<<;

    *DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<;

    *DIM AUDITTRAIL WHAT=BAS(TOTAL AUDIT); WHERE=<<<; USING=Input2; TOTAL=<<<;

    *DIM ENTITY WHAT=LADWP; WHERE=<<<; USING=<<<; TOTAL=<<<;

    *ENDALLOCATION

    Add comment
    10|10000 characters needed characters exceeded