Show contribution in percentages if element is reoccuring.

[swati_phadtare]

Hi,
How do I calculate contribution in terms of percentages for elements which are appearing at multiple places in given hierarchy(alternate hierarchy).
I have used "SCIB" element twice in the hierarchy under 2 different parent names. Now I want to show all actual values in terms of percentage where parent node should be 100% & all its child should show their contribution in terms of percent based on actuals. (total of child elements has to be 100).
Now issue is when I write rule for this, 1st SCIB coming under 1st parent shows correct value but 2nd SCIB coming under 2nd parent picks value of 1st SCIB.
Please guide me on the same
Thanks & Regards

Admin note: moved from enhancements.

[Michel Zijlema]

In TM1 an element is unique in the whole dimension and not just in the context of the hierarchy. So if you have an element SCIB that is part of two roll-ups than the SCIB element under the first parent is the same SCIB element as under the second parent. If you want to make these elements two seperate elements, you need to give the element different names in the different rollups, f.i. parent1_SCIB and parent2_SCIB.

Michel

[cycleman83]

Has anyone come up with a good solution to this issue?

I'm having the same problem... I'm trying to find the percent of the parent in a dimension which contains multiple hierarchies.

I have elements which have up to 8 unique parents, but I can't think of a good way to identify which parent is being used when my rule is being calculated.

[mvaspal]

Hi
As Michel wrote:
"if you have an element SCIB that is part of two roll-ups than the SCIB element under the first parent is the same SCIB element as under the second parent"

So if you want to display two different % values for the same element, I would recommend creating two measures for this. Then you can use the ELPAR function, its 3rd parameter is the hierarchy you want to use.