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.
Johannes Müller commented
...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).