Skip to Content
avatar image
Former Member

SAP BPC ALLOCATION SCRIPT - NOT WORKING

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Jan 11, 2017 at 01:22 PM

    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. ..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 06:27 AM

    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
    
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 06:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 07:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 09:45 AM

    ujkt.jpg

    Just posting the UJKT log.

    Will come up with some reports soon...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 12:14 PM

    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.
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 06:39 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 18, 2017 at 12:13 PM

    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
    Add comment
    10|10000 characters needed characters exceeded