Skip to Content
avatar image
Former Member

SAP BPC 10.1 NW - Making *RUNALLOCATION dynamic on nodes of a dimension

Hello BPC community and experts,

I'm currently struggling with the following problematic :

Let's suppose that I have the following dimensions :

CATEGORY : BUDGET

TIME : 2017.12

INDICATOR : VOLUME, EXPENSE

PRODUCT : A, B, C, D, E, F, G, H, etc.

The PRODUCT dimensions is built as follow :

I need to allocate the product that carries the expense on the other products of the same node, using the volume indicators.

For exemple : D is carrying the expense and should be allocated on the node ABCD

So my logic script would be :

This logic script works fine.

However I would like to dynamise it and to repeat the allocation to every nodes.

The next logical allocation would be the EXPENSE carried by H on the EFGH node...and so on. There is always a member of every node that carries the expense and should be allocated on the other members of the same node.

As anyone got an idea ?

Your advices will be really helpful.

Regards,

Karim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 05, 2017 at 03:18 PM

    Create a property in PRODUCT dimension like ALLOCPARENT

    Fill it:

    For D - ABCD

    For H - EFGH

    ...

    In the script:

    *SELECT(%SRCS%,[ID],PRODUCT,ALLOCPARENT<>'')
    *SELECT(%PARS%,[ALLOCPARENT],PRODUCT,ALLOCPARENT<>'')
    *FOR %SRC%=%SRCS% AND %PAR%=%PARS%
    ...
    *RUNALLOCATION
    ...
    *DIM PRODUCT WHAT=%SRC%; WHERE=BAS(%PAR%);...
    ...
    *NEXT

    Easy!

    Add comment
    10|10000 characters needed characters exceeded