question on unbalanced hierarchy

[gerrycastellino]

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

;

##############################################################