Skip to Content
0
Former Member
Apr 12, 2010 at 04:41 PM

Script Logic

29 Views

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