BPC Allocation Script Logic

[former_member591167]

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

[former_member591167]

Forgot to Add I am using BPC 10.1

[former_member186338]

Not nesessary:

SAP_BW 750 06 NW - only BPC 10.1 🙂

[former_member591167]

LGX:


*XDIM_MEMBERSET ENTITY = F002
*XDIM_MEMBERSET VERSION = ACTUAL
*XDIM_MEMBERSET TIME = 2017.11
*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 MATERIAL WHAT= BAS(ALL_MAT); WHERE=<<<; USING= NO_MAT; TOTAL= BAS(ALL_MAT)
*DIM DATASRC_COPA WHAT=SAP_BW; WHERE= DUTY_ALLC; USING= DUTY_LD; TOTAL=SAP_BW
*DIM TIME WHAT= 2017.11; WHERE=2017.11; USING=<<<; TOTAL=<<<
*DIM PROFIT_CTR WHAT=BAS(ALL_PC); WHERE=<<<; USING=PC_NONE; TOTAL= BAS(ALL_PC)
*ENDALLOCATION


-------------------------------------------------------------------------------------------------------------------------------------
LOG:


LOG BEGIN TIME:2018-09-07 11:19:48
FILE:\ROOT\WEBFOLDERS\YCNA_BPC_V \ADMINAPP\COPA_PRFT\TEST.LGF
USER:OMARM
APPSET:YCNA_BPC_V
APPLICATION:COPA_PRFT
FACTOR:USING/TOTAL
ALLOCATION DATA REGION:
ENTITY:F002,
VERSION:ACTUAL,
TIME:2017.11,
CURRENCY:USD,
ACCOUNT_COPA:STD_COST,
MATERIAL:110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN,
CUSTOMER:10000001,10000001_01,10000001_02,10000001_03,10000040,10000040_01,10000040_02,10000040_03,NO_CUST,
SHIP_TO:20000000,20000001,20000001_01,20000001_02,20000164,NO_SHIPTO,
ACCOUNT_COPA:WHAT:STD_COST,WHERE:BAD_DEBT,USING:BAD_DEBT,TOTAL:STD_COST
MATERIAL:WHAT:110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN,WHERE:<<<,USING:NO_MAT,TOTAL:110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN
DATASRC_COPA:WHAT:SAP_BW,WHERE:DUTY_ALLC,USING:DUTY_LD,TOTAL:SAP_BW
TIME:WHAT:2017.11,WHERE:2017.11,USING:<<<,TOTAL:<<<
PROFIT_CTR:WHAT:P1000,P100000,P1001,P1010,P1020,P1030,P1040,P1041,P1050,P1060,P1070,P1071,P2000,P2010,P2020,P301000,P301001,P301002,P301003,P301004,P301005,P302000,P302001,P302002,P303000,P303001,P303002,P304000,P304001,P304002,P305000,P305001,P305002,P400000,P500000,P600000,P700000,P999999,PC_NONE,PDUMMY,WHERE:<<<,USING:PC_NONE,TOTAL:P1000,P100000,P1001,P1010,P1020,P1030,P1040,P1041,P1050,P1060,P1070,P1071,P2000,P2010,P2020,P301000,P301001,P301002,P301003,P301004,P301005,P302000,P302001,P302002,P303000,P303001,P303002,P304000,P304001,P304002,P305000,P305001,P305002,P400000,P500000,P600000,P700000,P999999,PC_NONE,PDUMMY
-----------------------------------------
--Read WHAT region
[ACCOUNT_COPA] =STD_COST
[MATERIAL] =110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN
--Time to load WHAT :0.286694 second(s).
WHAT data:3  records.
-----------------------------------------
--Read USING region
[ACCOUNT_COPA] =BAD_DEBT
[MATERIAL] =NO_MAT
[DATASRC_COPA] =DUTY_LD
[PROFIT_CTR] =PC_NONE
[ENTITY] =F002
[VERSION] =ACTUAL
[CURRENCY] =USD
[CUSTOMER] =10000001,10000001_01,10000001_02
--Time to load USING :0.253196 second(s).
USING data:1  records.
-----------------------------------------
--Merge WHAT and USING
--Time to merge WHAT and USING :0.000073 second(s).
Data after merging WHAT and USING :0  records.
-----------------------------------------
--Apply factor
[ACCOUNT_COPA] =STD_COST
[MATERIAL] =110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN
TOTAL data:3  records.
WHERE=WHAT *USING/TOTAL
--Time to apply factor :0.285682 second(s).
-----------------------------------------
--Read destination and calculate difference
[ACCOUNT_COPA] =BAD_DEBT
[MATERIAL] =110000000,110277804,120021605,130216750,150051701,150051702,150051797,NO_MAT,ZDIN
--Time to read destination and calculate difference :0.295649 second(s).
-----------------------------------------
--Records succeeded to write back :0
-----------------------------------------
--Time to run Allocation :1.131737 second(s).


SCRIPT RUNNING TIME IN TOTAL:1.00 s.
LOG END TIME:2018-09-07 11:19:49

[former_member186338]

Please read help: https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/56b10a71d21b4f0eb69a4a79a050...

"Restriction of USING

• ...
• USING and TOTAL must have the same definition."

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)

[former_member591167]

In one of the previous iterations I had using and total the same but it didnt work. I will try again to see the results. ALso, I added the UJKT log for the above logic script.

[former_member186338]

I recommend you to start with simple samples! Then you will understand how it works!

[former_member591167]

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

[former_member186338]

Sorry, but you have to explain the required calculation logic very clear! Use reports screenshots with all dimensions visible.

For samples - search forum for "Vadim RUNALLOCATION"