on 09-07-2018 7:33 PM
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
Please read help: https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/56b10a71d21b4f0eb69a4a79a050...
"Restriction of USING
Unfortunately the data sample is not clear!
You have to clearly show what do you have for source data and what to use as FACTOR
Please read and test yourself help samples (there are some errors in the samples, by the way)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim
I have tried the simple using/total and it writes a record while only stating one DIM. Once I add another DIM, even without any scope it fails to write it. I am simply trying to allocate a value entered in 100 down to the part level in an account that doesn't have any part line items. The reference for part and percentage is the STD_COST line item detail. My picture shows the user entering in the 100 and for MAT 1 200/2400 = 8%, than the 8% of the 100 is posting as bad_debt/mat1/$8.
The allocation is finding the values required for calculation but than when it writes, -Records succeeded to write back :0
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM ACCOUNT_COPA WHAT= BAD_DEBT; WHERE= BAD_DEBT; USING= STD_COST; TOTAL= <<<
*DIM TIME WHAT= 2017.11; WHERE=2017.12; USING=2017.11; TOTAL=<<<
*DIM CURRENCY WHAT = USD; WHERE=USD; USING=USD; TOTAL= <<<
*DIM MATERIAL WHAT= NO_MAT; WHERE=120021605; USING= >>>; TOTAL= BAS(ALL_MAT)
*DIM VERSION WHAT = ACTUAL; WHERE=ACTUAL; USING=ACTUAL; TOTAL=ACTUAL
*DIM DATASRC_COPA WHAT=DUTY_LD; WHERE= DUTY_ALLC; USING= SAP_BW; TOTAL=<<<
*DIM ENTITY WHAT= F002; WHERE=<<<; USING= F002; TOTAL=<<<
*DIM PROFIT_CTR WHAT=PC_NONE; WHERE=P301000; USING=>>>; TOTAL= BAS(ALL_PC)
*ENDALLOCATION
User | Count |
---|---|
9 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.