Allocate data from parent to child node

[AlejandroMoreno4]

Hello, SAC community:

I have a dimension product with 2 hierarchies, one with multiple levels and the other one with the parents as root members. It looks like this:

In H1, 010105 has 0101 as parent, and 0101 has 01 as parent. In H2, only 01 appears as <root>. I'd like to introduce data at parent level using H2 and then be able to allocate it to its children equally or with weights depending in another year, for example. Is there any way to do this in a Data Action?

I've also thought about creating some dummy leaf members and showing these when the user inputs the data, but I don't know how to allocate the data if the data is in a leaf member. Doing a loop seems useless since it would need a parameter for each member that tells the number of siblings it has, and that just feels like bad desing.

Thank you in advance.

[Yogeshwar_M]

Hi @AlejandroMoreno4,

In model level you can do allocation by creating reference measure.

Copy last year data to that reference measure.

In main measure select aggregation type "reference to another measure"

Select this newly created measure as reference measure 

Select option "Total Distribution"

After that whenever you input data in current year it will allocate data based on last year's input percentage.

Thanks.