TM1 Forum

Hi All,

I have an issue when trying to create a new hierachy with subset elements. Subset name would be new hierachy name and all its elements should be rolled up to the hierarchy. Issue is with consolidated elements being duplicated in hierarchy.

Hierarchy should hold only consolidated elements of highest level. Suggest me a way to pick only cosolidated elements of top level in the subset.



Please see below scenario:

Subset Name: Region

Subset Structure:

Americas - Level 3
- USA - Level 2
- California - Leaf Level
- Texas - Leaf Level

Asia - Level 3

- Japan - Level 2
- Kanto - Leaf Level
- India - Level 2
- Kerala - Leaf Level
- Karnataka - Leaf Level

This is how hierarchy is getting craeated :

Country
- Americas
- USA
- Asia
- Japan
- India
-USA
-Japan
-India


Thanks,
ArB

You've shown what's being created, but I think it would be beneficial to also share what exactly you want the hierarchy to look like.

If you want your new hierarchy to have the Level 3 parent and then leaf level elements as immediate children, you can use ELLEV in your TI to make sure you're only adding elements to the new hierarchy from the base hierarchy subset that are Level 3 or Level 0.

Sharing actual code from your TI will help too.