Skip to Content
0
Former Member
Nov 17, 2012 at 06:08 AM

Allocation Script

48 Views

Dear BPC Experts,

For example: I have 3 parent ID in Product dimension: Product A, Product B, and Product C. Those parent ID have base members ID, Product A:A1,A2,A3, Product B:B1,B2,B3, Product C: C1,C2,C3. I would like to alocate amount from a particular product for its base members ID. Amount of Product A will allocate to A1,A2,A3 based on % allocation amount. I know that Product A,B,C is a parent ID and could not save amounts, So I created a new ID tempA, tempB, tempC. I used allocation script such as below for allocate TempA Amount to base members of Product A:

*RUNALLOCATION

*FACTOR=USING

---

*DIM ACCOUNT WHAT=ACC01; WHERE=<<<; USING=ACC02;

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

*ENDALLOCATION

The above script ran successfully for one product scenario. I would like to use it for several products, TempB amount to base members of Product B and TempC amount to base members of Product C. My idea to use a comma in WHAT statement of Product dimension.

*DIM PRODUCT WHAT=TEMPA,TEMPB,TEMPC; WHERE=BAS(PRODUCTA),BAS(PRODUCTB),BAS(PRODUCTC); USING=<<<;

OR

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

*DIM PRODUCT WHAT=TEMPB; WHERE=BAS(PRODUCTB); USING=<<<;

*DIM PRODUCT WHAT=TEMPC; WHERE=BAS(PRODUCTC); USING=<<<;

Is it correct? Do you have any suggestions please?

Kind Regards,