Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Planned
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

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.
  • ADMIN RESPONSE
    Aug 19, 2022

    Thanks for this idea. We think it is a good one. We have started an internal process for the implementation of this feature. Watch this space!

  • Attach files
  • Guest
    Jun 23, 2022

    Actually it might be a little bit ashaming for a modern OLAP server
    to not be able do determine a parent 100% reliable in parallel hierarchies.

    ..knowing that other OLAP Servers (especially MDX based) have this as a standard function since more than 20 years

    [Dimx].[Hierarchy_A].[Member].Parent

    [Dimx].[Hierarchy_B].[Member].Parent


    I hope that Jedox will also realise that this is a valid need in real life environments.

    I agree with the comment from March 2022, it would make development a lot easier in several cases.

  • Guest
    Mar 15, 2022

    I have been looking for those functions since I began with Jedox. This would cut at least 30% of my supervision server custom developments

  • Guest
    Jul 2, 2019
    ...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).