Create a drillable consolidator with only leaf level children

[JamiseBondi]

Hi guys,

I'm trying to create a dynamic subset that shows a collapsed consolidated node that when expanded, only shows the leaf level children (not any consolidated children). Does anyone have any hints? I've gone through the "MDX a primer" site (http://www.bihints.com/book/export/html/68) and been searching on TM1 reference guide but haven't found anything that does the trick yet.
Many thanks.

[Wim Gielis]

Hi guys,

I'm trying to create a dynamic subset that shows a collapsed consolidated node that when expanded, only shows the leaf level children (not any consolidated children). Does anyone have any hints? I've gone through the "MDX a primer" site (http://www.bihints.com/book/export/html/68) and been searching on TM1 reference guide but haven't found anything that does the trick yet.
Many thanks.

Hi

That cannot be done natively.
You need to set up a parallel hierarchy in the same dimension.
Either with the new hierarchies feature in TM1, either using a TI process (or manual copy/paste) to set up and maintain the parallel hierarchy.

[JamiseBondi]

Thanks Wim for confirming! much appreciated.

[lotsaram]

I'm trying to create a dynamic subset that shows a collapsed consolidated node that when expanded, only shows the leaf level children (not any consolidated children). Does anyone have any hints?

You could achieve this with separate subsets (e.g. a "summary" subset and a "drilled" subset) but it isn't achievable by clicking on the "+" to expand a consolidated element. The moment you expand an element you are no longer looking at your original subset and you are drilling into the live dimension structure and you will obtain the children of the consolidation. If you want to skip all intermediate levels and go straight from a consolidation to the leaf descendants then you would need to define an alternate (flat) rollup to expand into.

[JamiseBondi]

Thanks lotsaram, very helpful, much appreciated.

[tm123]

The workaround i use is, in the websheet, i use checkbox “Drill to Leaf Elements” and then i create a dynamic MDX statement to be used in the TM1RPTRow, so if the user selects the CheckBox, the Active form shows the Dimension Total element and Leaf Elements, otherwise the active form shows the total elemny only

Toggling the checkbox, requires the websheet to be rebuild so i use an action button beside the checkbox