I have a hierarchy that is unbalanced.
So I could have in my hierachy leaf nodes anywhere from level 2 to level 6.
Now I need to join NodeName in my hierarchy structure to another table, but only display in a pivot chart up to the relevant leaf level.
How can I build a dynamic dimension list that knows how to display a leaf at the right level and not beyond that.
##############################################################
Hierarchy(NodeId, ParentId, NodeName, , ,NodePath,|, NodeDepth)
LOAD
Node as NodeId,
Parent as ParentId,
NodeName as NodeName,
NodeName as REP_SUB_BS_ITEM,
IS_LEAF,
PRIORITY
FROM
;
##############################################################