cancel
Showing results for 
Search instead for 
Did you mean: 

RUN ALLOCATION

0 Kudos
100

Hi

Trying to run allocation using RUNALLOCATION in SAP BPC Script logic (Version - S4/HANA - SAP BPC 11.0)

expected-output.jpg

As shown in the attached excel we have

Account Dimension

PERCENT - This is entered for each product SKU

COST - This will be input only at PRODA_INPUT level which we are expecting to be allocated basis the % entered

ALLOC_COST - This is the account where the allocated cost to be computed.

Product Dimension

PRODA_TOTAL is Parent and having 6 base level members below it

PRODA_INPUT is the member where total cost will be entered.

SCRIPT LOGIC is as below

*XDIM_MEMBERSET S_TIME = %S_TIME_SET%

*XDIM_MEMBERSET S_CATEGORY = %S_CATEGORY_SET%

*XDIM_MEMBERSET S_ENTITY = %S_ENTITY_SET%

*XDIM_MEMBERSET S_ACCOUNT = PERCENT,COST,ALLOC_COST

*XDIM_MEMBERSET S_PRODUCT = PRODA_INPUT,BAS(PRODA_TOTAL)

*RUNALLOCATION *FACTOR=USING/100

*DIM S_ACCOUNT WHAT=COST; WHERE=ALLOC_COST; USING=PERCENT

*DIM S_VEHICLE WHAT=PRODA_INPUT; WHERE=BAS(PRODA_TOTAL); USING=<<<

*ENDALLOCATION

Expecting output as shown in the image file for account ALLOC_COST. However when I execute the above script it shows as succeeded but do not see anything computed under ALLOC_COST when I refresh the sheet.

former_member186338
Active Contributor
0 Kudos

Please, never use "Insert File" instead of correct "Insert Image" for screenshots. I will not answer questions with "Insert File"!

Also, please provide the log of script run.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Please read S_VEHICLE as S_PRODUCT.