COGNOiSe.com - The IBM Cognos Community

Hi Guys,

I have TM1 application where users capture on the last/lowest level,my hierarchy is unbalanced , so each level can have different number of leafs. on report studio i need to display all the lowest levels of that ragged hierarchy.

Please let me know how i can achieve above scenario?

Thanks.
Spharingo

Quote from: Spharingo on 11 Sep 2015 02:47:13 AM
Hi Guys,

I have TM1 application where users capture on the last/lowest level,my hierarchy is unbalanced , so each level can have different number of leafs. on report studio i need to display all the lowest levels of that ragged hierarchy.

Please let me know how i can achieve above scenario?

Thanks.
Spharingo

The short answer is... you can't. If the leaf members are at different levels across the hierarchy, there is no easy way to show them in your report. The best solution is for you to balance the hierarchy within TM1, so that all the leaf members are at a fixed level at the bottom of the hierarchy.

MF.

Thanks a lot MFGF