How can we improve Jedox Software?

PALO.EPARENT and PALO.ELEVEL relative to specific root element (parallel hierarchies)

PALO.EPARENT and PALO.ELEVEL work well if you have only 1 hierarchy within a dimension.

But if you have more than one hierarchy it would be great to give a certain root element as parameter and get the parent and or the level in exactly this specific tree.

13 votes
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Jens Lorentz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
Signed in as (Sign out)
  • Johannes Müller commented  ·   ·  Flag as inappropriate

    ...very useful also from within a DynaRange combined with Conditional Formatting. Currently the level of deepness within a DynaRange can not be determined reliably with these functions - you have to use a custom macro (slow).

Feedback and Knowledge Base