Skip to Content

Script Logic - RUNALLOCATION

Hi,

Please help with folowing scenario in Script logic :-

We have to move a value planned at Company code level (maintained inside ENTITY Dimesion) to Cost Center level based on Actuals.

We have separate dimensions for ENTITY, COSTCENTER AND FUNCTIONAL AREA. And inside Cost center dimension we have functional area property and Entity property.

Master data for cost center dimension is maintained as follows:-

Cost Center dimension

ID FUNC_AREA (Property) C_CODE(Property) C_1000 F_400 E_1000 C_2000 F_500 E_1000 C_3000 F_400 E_1000 C_4000 F_500 E_1000 C_5000 F_400 E_1000

Test data sample for the scenario Company code level data - Input (Actuals) (Plan) Company Code Cost center Functional Area 2012.08 2012.09 E_1000 DEFAULT_CC DEFAULT_FA 200 500

We have to distribute the same to all the cost centers mapped to this company code based on Actuals. So the output will be as follows:- Cost Center level Data - Output (Actuals) (Plan - To be found out) Company code Cost center Functional Area 2012.08 2012.09 E_1000 C_1000 F_400 30 =500*30/200 = 75 E_1000 C_2000 F_500 40 =500*40/200 = 100 E_1000 C_3000 F_400 35 =500*D30/200 = 87.5 E_1000 C_4000 F_500 45 =500*45/200 = 112.5 E_1000 C_5000 F_400 50 =500*50/200 = 125

*SELECT(%COSTCENTER%,[ID],COSTCENTER,[C_CODE]=E_1000) /// C_1000,C_2000,C_3000,C_4000,C_5000 will be scoped inside the variable *FOR %CC% = %COSTCENTER% *RUNALLOCATION *FACTOR = USING/TOTAL *DIM ENTITY WHAT = E_1000 ; WHERE = E_1000 ; USING = E_1000 ; TOTAL = E_1000 *DIM COSTCENTER WHAT = DEFAULT_CC ; WHERE = %CC% ; USING = %CC% ; TOTAL = DEFAULT_CC *DIM FUNC_AREA WHAT = DEFAULT_FA ; WHERE =<FUNC_AREA Property value maintianed inside the cost center dimension> ; USING = <FUNC_AREA Property value maintianed inside the cost center dimension> ; TOTAL = DEFAULT_FA *ENDALLOCATION *NEXT

Please help us with the syntax that can be called inside the RUNALLOCATION for a dimension which is maintained as a property in another dimension. Versiondetails :- BPC 10.0 NW Version BW Config details SW Component Release Level Highest support package Description BI_CONT 747 2 SAPK-74702INBICONT Business Intelligence Content BI_CONT_XT 747 2 SAPK-74702INBICONTXT Business Intelligence Content for Bobj I SAP_BW 731 4 SAPKW73104 SAP Business Warehouse

Regards,

Sreeja V

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Apr 02, 2015 at 08:52 AM

    Hi Sreeja,

    You have for ACTUAL for the COMPANY E_1000:

    Same for other companies...

    The script is like:

    //Select All CC and FA except DEFAULT

    *SELECT(%CC%,[ID],COSTCENTER,[ID]<>DEFAULT_CC AND [CALC]=N)

    *SELECT(%FA%,[ID],FUNC_AREA,[ID]<>DEFAULT_FA AND [CALC]=N)

    *RUNALLOCATION

    *FACTOR = USING/TOTAL

    //%ENTITY_SET%- list of required entities

    *DIM_NONAGGR ENTITY WHAT=%ENTITY_SET%; WHERE=<<<; USING=<<<; TOTAL=<<<

    *DIM COSTCENTER WHAT=DEFAULT_CC; WHERE=%CC%; USING=<<<; TOTAL=<<<

    *DIM FUNC_AREA WHAT=DEFAULT_FA; WHERE=%FA%; USING=<<<; TOTAL=<<<

    *DIM CATEGORY WHAT=Plan; WHERE=<<<; USING=Actual; Total=<<<

    *ENDALLOCATION

    Vadim


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2015 at 07:55 AM

    Hi Sreeja,

    First, you need to manually input 30,40,35,45,50 into the target area in 2012.08. Because RUNALLOCATION could not decide the factor why 200 need to be seperated as 30,40,35,45,50.

    Then you can use RUNALLOCATION to distribute the data automatically to 75,100,87.5,112.5,125 beased on the "source data":200,500, and "factor data": 30,40,35,45,50. Just simply add the member into WHERE & USING area like:

    *DIM FUNC_AREA WHAT=DEFAULT_FA; WHERE=F_400,F500; USING=<<<;TOTAL=<<<;

    Best Regards,

    Arjen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.