Skip to Content
0

SAP BPC ALLOCATION SCRIPT - NOT WORKING

Jan 11, 2017 at 01:12 PM

121

avatar image

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. I have two screen shots showing the business requirements.

*XDIM_MEMBERSET CATEGORY = Actual

*RUNALLOCATION

*FACTOR = USING

*DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=<<<; USING=PROPORTIONS;

*DIM BU_DIV WHAT=NO_BU_DIV; WHERE=BAS(TOTAL_BU_DIV); USING=<<<;

*DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; TOTAL=<<<;

*DIM AUDITTRAIL WHAT=BAS(TOTAL AUDIT); WHERE=<<<; USING=Input2; TOTAL=<<<;

*DIM ENTITY WHAT=LADWP; WHERE=<<<; USING=<<<; TOTAL=<<<;

*ENDALLOCATION

example.jpg

example-1.jpg

example.jpg (61.2 kB)
example-1.jpg (72.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Vadim Kalinin Jan 11, 2017 at 01:22 PM
0

The script contains a number of errors...

What do you mean by BAS(TOTAL AUDIT) - you don't have this member!

RPTCURGENCY has to be specified in XDIM_MEMBERSET. ..

Show 1 Share
10 |10000 characters needed characters left characters exceeded

P.S. you have factor USING but you specify TOTAL..

Please read help about RUNALLOCATION...

0
Joji Joseph Jan 12, 2017 at 06:27 AM
0

Hi Kalinini

We have modified the code as follows and still not working. Please have a look

*XDIM_MEMBERSET COST_ELEMET= 52,53,54,56,BAS(POOL_COST)
*XDIM_MEMBERSET RPTCURRENCY = USD
*XDIM_MEMBERSET CATEGORY = Actual
*XDIM_MEMBERSET AUDITTRAIL= Input2,Input
*XDIM_MEMBERSET ENTITY = LADWP
*XDIM_MEMBERSET BU_DIV = BAS(TOTAL_BU_DIV)

*RUNALLOCATION

*FACTOR=USING
*DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=52,53,55,56; USING=<<<;

*DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<;

*DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<;

*DIM AUDITTRAIL WHAT=BAS(AuditTotal); WHERE=<<<; USING=Input2;

*DIM ENTITY WHAT=LADWP; WHERE=<<<; USING=<<<;

*ENDALLOCATION

,
Hi Kalinin
we have modified the code as follows still not working, Please have a look
*XDIM_MEMBERSET COST_ELEMET= 52,53,54,56,BAS(POOL_COST)
*XDIM_MEMBERSET RPTCURRENCY = USD
*XDIM_MEMBERSET CATEGORY = Actual
*XDIM_MEMBERSET AUDITTRAIL= Input2,Input
*XDIM_MEMBERSET ENTITY = LADWP
*XDIM_MEMBERSET BU_DIV = BAS(TOTAL_BU_DIV)
*RUNALLOCATION
*FACTOR=USING
*DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=52,53,55,56; USING=<<<;
*DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<;
*DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<; 
*DIM AUDITTRAIL WHAT=BAS(AuditTotal); WHERE=<<<; USING=Input2; 
*DIM ENTITY WHAT=LADWP; WHERE=<<<; USING=<<<; 
*ENDALLOCATION
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 12, 2017 at 06:59 AM
0

Sorry, but "still not working" is a meaningless comment. You have to explain all details with test data sample and UJKT log of script run.

Share
10 |10000 characters needed characters left characters exceeded
Joji Joseph Jan 12, 2017 at 07:37 AM
0

Hi Kalinini

1. screen-shot-requirement.jpg

The screen shows the requirement where in the total Pool cost 149053 has to be allocated to different business units ( 01,02 etc..). Here Pool Cost , 52( Fleet Equipment) ,53( Fleet Op Charges ) etc. has been allocated under dimension COST_ELEMET( Account Cost Element) and 01( Comm Office),02 ( Off of city attorney) etc.. has been allocated under dimension Business Division ( BU _DIV).

2. We have created an input form with Audit Trail Input 2 and have all the driver details .driver-details.jpg

3. The total Pool Cost is entered via another input form with Audit Trail - AuditTotal total-pool-cost.jpg

4. The report ( final) should be allocated based on the driver cost multiplied by the total pool cost among all the individual business units under the account cost element.

5, When I Tried executing the above code in UJKT there was no log found. ujkt.jpg (Screen Shot Attached).

Thanks

JJ


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but you are incorrectly using UJKT. Please read https://blogs.sap.com/2012/08/20/testing-logic-script-ujkt/

0

And instead of screenshots of your real input forms (hard to understand) please create some simple reports:

1. What data

2. Using data

3. Required result to be stored (multiplication of what and using)

0
Joji Joseph Jan 12, 2017 at 09:45 AM
0

ujkt.jpg

Just posting the UJKT log.

Will come up with some reports soon...


ujkt.jpg (217.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Log has to be posted as text not as screenshot!

0
Joji Joseph Jan 12, 2017 at 12:14 PM
0

LOG: FILE:\ROOT\WEBFOLDERS\LADWP \ADMINAPP\FLEET_SERVICES\TEST.LGF
USER:JOJIJO
APPSET:LADWP
APPLICATION:FLEET_SERVICES
FACTOR:USING
ALLOCATION DATA REGION:
COST_ELEMET:52,53,54,56,7100001,7100002,7100003,7100004,7100005,7117116,7357313,
RPTCURRENCY:USD,
CATEGORY:Actual,
AUDITTRAIL:Input,Input2,
ENTITY:LADWP,
BU_DIV:01,02,04,06,07,08,11,16,17,20,21,22,25,26,27,31,33,35,36,37,38,39,41,43,44,45,48,60,61,65,66,69,70,72,74,75,76,77,78,79,96,
COST_ELEMET:WHAT:7100001,7100002,7100003,7117116,7357313,7100004,7100005,WHERE:52,53,55,56,USING:<<<,TOTAL:
BU_DIV:WHAT:04,08,26,45,61,07,17,48,72,75,01,11,21,66,78,16,20,22,31,33,44,69,76,77,02,25,36,39,43,74,37,38,06,27,41,60,65,70,79,35,96,WHERE:04,08,26,45,61,07,17,48,72,75,01,11,21,66,78,16,20,22,31,33,44,69,76,77,02,25,36,39,43,74,37,38,06,27,41,60,65,70,79,35,96,USING:<<<,TOTAL:
RPTCURRENCY:WHAT:USD,WHERE:<<<,USING:<<<,TOTAL:
AUDITTRAIL:WHAT:Allocation,Other,Input,Upload,WHERE:<<<,USING:Input2,TOTAL:
ENTITY:WHAT:LADWP,WHERE:<<<,USING:<<<,TOTAL:

SCRIPT RUNNING TIME IN TOTAL:1.00 s.
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 12, 2017 at 06:39 PM
0

Waiting for clear reports. And the log shows that the script is not running.

Share
10 |10000 characters needed characters left characters exceeded
Joji Joseph Jan 18, 2017 at 12:13 PM
0

Pasting the log once again

LGX: *XDIM_MEMBERSET COST_ELEMET= 52,53,54,56,BAS(POOL_COST)
*XDIM_MEMBERSET RPTCURRENCY = USD
*XDIM_MEMBERSET CATEGORY = Actual
*XDIM_MEMBERSET AUDITTRAIL= Input2,Input
*XDIM_MEMBERSET ENTITY = LADWP
*XDIM_MEMBERSET BU_DIV = BAS(TOTAL_BU_DIV)
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM COST_ELEMET WHAT=BAS(POOL_COST); WHERE=52,53,55,56; USING=<<<;TOTAL=<<<;
*DIM BU_DIV WHAT=BAS(TOTAL_BU_DIV); WHERE=BAS(TOTAL_BU_DIV); USING=<<<;TOTAL=<<<;
*DIM RPTCURRENCY WHAT=USD; WHERE=<<<; USING=<<<;TOTAL=<<<;
*DIM AUDITTRAIL WHAT=BAS(AuditTotal); WHERE=<<<; USING=Input2;TOTAL=<<<;
*DIM ENTITY WHAT=LADWP; WHERE=<<<; USING=<<<;TOTAL=<<<;
*ENDALLOCATION
*COMMIT -------------------------------------------------------------------------------------------------------------------------------------
LOG: LOG BEGIN TIME:2017-01-18 06:10:22
FILE:\ROOT\WEBFOLDERS\LADWP \ADMINAPP\FLEET_SERVICES\TEST.LGF
USER:JOJIJO
APPSET:LADWP
APPLICATION:FLEET_SERVICES
FACTOR:USING/TOTAL
ALLOCATION DATA REGION:
COST_ELEMET:52,53,54,56,7100001,7100002,7100003,7100004,7100005,7117116,7357313,
RPTCURRENCY:USD,
CATEGORY:Actual,
AUDITTRAIL:Input,Input2,
ENTITY:LADWP,
BU_DIV:01,02,04,06,07,08,11,16,17,20,21,22,25,26,27,31,33,35,36,37,38,39,41,43,44,45,48,60,61,65,66,69,70,72,74,75,76,77,78,79,96,
COST_ELEMET:WHAT:7100001,7100002,7100003,7117116,7357313,7100004,7100005,WHERE:52,53,55,56,USING:<<<,TOTAL:<<<
BU_DIV:WHAT:04,08,26,45,61,07,17,48,72,75,01,11,21,66,78,16,20,22,31,33,44,69,76,77,02,25,36,39,43,74,37,38,06,27,41,60,65,70,79,35,96,WHERE:04,08,26,45,61,07,17,48,72,75,01,11,21,66,78,16,20,22,31,33,44,69,76,77,02,25,36,39,43,74,37,38,06,27,41,60,65,70,79,35,96,USING:<<<,TOTAL:<<<
RPTCURRENCY:WHAT:USD,WHERE:<<<,USING:<<<,TOTAL:<<<
AUDITTRAIL:WHAT:Allocation,Other,Input,Upload,WHERE:<<<,USING:Input2,TOTAL:<<<
ENTITY:WHAT:LADWP,WHERE:<<<,USING:<<<,TOTAL:<<<
-----------------------------------------
--Read WHAT region
[COST_ELEMET] =7100001,7100002,7100003,7100004,7100005,7117116,7357313
[AUDITTRAIL] =Allocation,Input,Other
--Time to load WHAT :0.126877 second(s).
WHAT data:0 records.
-----------------------------------------
--Read USING region
[COST_ELEMET] =52,53,55,56
[AUDITTRAIL] =Input2
[CATEGORY] =Actual
[BU_DIV] =01,02,04,06
--Time to load USING :0.168059 second(s).
USING data:326 records.
-----------------------------------------
--Merge WHAT and USING
--Time to merge WHAT and USING :0.002654 second(s).
Data after merging WHAT and USING :0 records.
-----------------------------------------
--Apply factor
[COST_ELEMET] =52,53,55,56
[AUDITTRAIL] =Input2
[CATEGORY] =Actual
[BU_DIV] =01,02,04,06
TOTAL data:326 records.
WHERE=WHAT *USING/TOTAL
--Time to apply factor :0.236044 second(s).
-----------------------------------------
--Read destination and calculate difference
[COST_ELEMET] =52,53,55,56
[AUDITTRAIL] =Allocation,Input,Other,Upload
[CATEGORY] =Actual
[BU_DIV] =01
--Time to read destination and calculate difference :0.173086 second(s).
-----------------------------------------
--Records succeeded to write back :1
--Records failed to write back :0
-----------------------------------------
--Time to run Allocation :0.729359 second(s).

SCRIPT RUNNING TIME IN TOTAL:0.00 s.
LOG END TIME:2017-01-18 06:10:22
Show 1 Share
10 |10000 characters needed characters left characters exceeded

You have no data in What:

WHAT data:0 records.

0