MDX Help needed: rollup recursively from element to root level?

[foogy]

Hi there,

I was wondering if there is some smart way to achieve kind of a"reversed" TMDRILLDOWNMEMBER (..., ALL, RECURSIVE) for a given dimension element.

The idea is to let the user drill through a hierarchy via Hyperlinks, and on each click, the active form will use the clicked element as new entry point and drill down the next 2 levels or so. On reaching the end of the new drill, the user can expand further, or - if list of elements gets too long - can click an element and set it as new entry point.

However, this works fine. The thing is, I would like to show the path from hierarchy root down to selected entry element as well, to always keep the top sum visible and visualize the changes on elements on a higher level, once the user changes a figure.

So, given a number of Levels (7 Levels in my case), how would I roll up from let's say an element on Level 4 up to the root element? I could nest several ROLLUP statements, however I do not really like that approach, as the nesting level is dependent on the number of levels and dynamic code generation for the MDX would be rather tricky. A TM1ROLLUPMEMBER (..., ALL, RECURSIVE) would be great, but doesn't exist

Any suggestion or similar situation to share your experiences? Thanks a lot!

[gtonkin]

Try something like this:

Code: Select all

HIERARCHIZE({Ascendants([<dim>].[<element>])})

If the elements exists in multiple hierarchies, only the first is returned.

[foogy]

Thanks, that did exactly what I need. I never used Ascendants command, and obviously thinking how to solve that in a nested way drove me in the wrong direction.

Rgds