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,