Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP BPC ALLOCATION SCRIPT - NOT WORKING

Former Member

on ‎2017 Jan 11 1:12 PM

0 Likes
1,289

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

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
‎2017 Jan 18 12:13 PM
0 Likes

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 replies
Show replies
former_member186338
Active Contributor
‎2017 Jan 18 12:27 PM
0 Likes

You have no data in What:

WHAT data:0 records.

former_member186338
Active Contributor
‎2017 Jan 12 6:39 PM
0 Likes

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

Show replies
Show replies
Former Member
‎2017 Jan 12 12:14 PM
0 Likes

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.
Show replies
Show replies
Former Member
‎2017 Jan 12 9:45 AM
0 Likes

ujkt.jpg

Just posting the UJKT log.

Will come up with some reports soon...

Show replies
Show replies
former_member186338
Active Contributor
‎2017 Jan 12 10:25 AM
0 Likes

Log has to be posted as text not as screenshot!

Former Member
‎2017 Jan 12 7:37 AM
0 Likes

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 replies
Show replies
former_member186338
Active Contributor
‎2017 Jan 12 8:22 AM
0 Likes

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

former_member186338
Active Contributor
‎2017 Jan 12 8:32 AM
0 Likes

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)

former_member186338
Active Contributor
‎2017 Jan 12 6:59 AM
0 Likes

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.

Show replies
Show replies
Former Member
‎2017 Jan 12 6:27 AM
0 Likes

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
Show replies
Show replies
former_member186338
Active Contributor
‎2017 Jan 11 1:22 PM
0 Likes

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 replies
Show replies
former_member186338
Active Contributor
‎2017 Jan 11 1:24 PM
0 Likes

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

Please read help about RUNALLOCATION...

Ask a Question