Skip to Content
0
Former Member
Jan 11, 2017 at 07:24 AM

SAP BPC ALLOCATION SCRIPT

189 Views Last edit Jan 27, 2017 at 04:40 PM 2 rev

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