Hi all
I am new to script logic and don't seem to have a solution for the following problem. I am inputting values to a member in Product dimension which acts as a dummy member to input values at a parent node and I need to allocate that value to individual products based on percentages. So the Product dimension looks something like this -
ID | Parent | Dummy
PF1 |
P1 | PF | PF1_D
P2 | PF | PF1_D
P3 | PF | PF1_D
PF1_D |
(Dummy is a property in Product dimension)
PF1 is parent of P1,P2 and P3. PF1_D is the dummy member which is used to input data at PF1 level (I can't input data directly to PF1 since it is a parent member). Data is input at the intersection of Product = "PF1_D" and Datasrc = "INPUT".
My requirement now is to allocate the amount input at PF1_D to the children of PF1 (marked by property Product.Dummy = "PF1_D") by a percentage stored in the database. The percentages are stored at the intersection of DATASRC = "INPUTPER" and the individual products = "P1","P2","P3". The results need to written at the intersection of DATASRC = "INPUT" and the individual products = "P1","P2","P3".
Please help.
Thanks,
Ameya Kulkarni