Member Property used in RUNALLOCATION script logic

[kyle_tetschlag]

Hi All

Using BPC 10.1 NW, I'd like to create allocation script.

Dimensions:

ACCOUNT

TIME

PRODUCT

Business scenario: I have loaded market growth assumptions to PRODUCT (PRODUCTA, B and C) members which are a property (INPUTNODE) of our main PRODUCT (PRODUCT1 - PRODUCT5) members. There are multiple product members with the same property (INPUTNODE). I need a script that can take these market growth assumptions (percentages), multiply against units that have been loaded to main PRODUCT (PRODUCT1 - PRODUCT5) members come up with next year plan units.

Below is the allocation rule I have set up and works well for the one product property. I need to know how to make this dynamic to do for all base members of PRODUCT dimension.

*RUNALLOCATION

*FACTOR = USING

*DIM ACCOUNT WHAT = MKTGROWTH; WHERE = UNIT_ORDER;USING = <<<

*DIM PRODUCT WHAT = PRODUCTA.INP; WHERE = BAS(PRODUCTA); USING = <<<

*DIM TIME WHAT = 2022.01; WHERE = <<< ; USING = BAS(2021.TOTAL)

*ENDALLOCATION

PRODUCT DIMENSION (INPUTNODE is property of PRODUCT)

[ID] - PRODUCT1 [INPUTNODE] - PRODUCTA

[ID] - PRODUCT2 [INPUTNODE] - PRODUCTA

[ID] - PRODUCT3 [INPUTNODE] - PRODUCTA

[ID] - PRODUCT4 [INPUTNODE] - PRODUCTB

[ID] - PRODUCT5 [INPUTNODE] - PRODUCTB

[ID] - PRODUCT6 [INPUTNODE] - PRODUCTC

[ID] - PRODUCTA

[ID] - PRODUCTB

[ID] - PRODUCTC

[former_member186338 · Accepted solution]

Instead of RUNALLOCATION use LOOKUP and when/endwhen

*LOOKUP SameModel
*DIM INP:PRODUCT=PRODUCT.INPUTNODE
...
*ENDLOOKUP

*WHEN PRODUCT
*IS ...
*REC(EXPRESSION=%VALUE%*LOOKUP(INP)...
*ENDWHEN

For extra details - please provide full info based on:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/