Hi
I am new to BPC RUNALLOCATION and have been looking at all the forums related to issues with incorrect data. I created a script that works when my what and using have all the same dimensions. What i am trying to accomplish is allocating an amount posted by the users through Input form or DM. The amount will post to the same account that it will require the allocation but the basis will be COGS per material/Total COGS. I have tried about 10 different iterations in UJKT but unable to write any records due to the error below.
Error--Merge WHAT and USING --Time to merge WHAT and USING :0.000073 second(s). Data after merging WHAT and USING :0 records.
System: SAP_BW 750 06 NW
I understand my scope is not all required but this was the latest i used to try to limit as much as possible.
Logic Script:
*XDIM_MEMBERSET ENTITY = F002 *XDIM_MEMBERSET VERSION = ACTUAL *XDIM_MEMBERSET TIME = %TIME_SET% *XDIM_MEMBERSET CURRENCY = USD *XDIM_MEMBERSET ACCOUNT_COPA = STD_COST *XDIM_MEMBERSET MATERIAL = BAS(ALL_MAT) *XDIM_MEMBERSET CUSTOMER = BAS(YTC_ALL) *XDIM_MEMBERSET SHIP_TO = BAS(ALL_SHIPTO) *RUNALLOCATION *FACTOR=USING/TOTAL *DIM ACCOUNT_COPA WHAT= STD_COST; WHERE= BAD_DEBT; USING= BAD_DEBT; TOTAL= STD_COST //*DIM CURRENCY WHAT = USD; WHERE=<<<; USING=USD; TOTAL= <<< *DIM MATERIAL WHAT= BAS(ALL_MAT); WHERE=<<<; USING= NO_MAT; TOTAL= BAS(ALL_MAT) //*DIM VERSION WHAT = ACTUAL; WHERE=ACTUAL; USING=ACTUAL; TOTAL=ACTUAL *DIM DATASRC_COPA WHAT=SAP_BW; WHERE= DUTY_ALLC; USING= DUTY_LD; TOTAL=SAP_BW *DIM TIME WHAT= %TIME_SET%; WHERE=%TIME_SET%; USING=<<<; TOTAL=<<< //*DIM ENTITY WHAT= F002; WHERE=<<<; USING= F002; TOTAL=<<< *DIM PROFIT_CTR WHAT=BAS(ALL_PC); WHERE=<<<; USING=PC_NONE; TOTAL= BAS(ALL_PC) *ENDALLOCATION