Need Help in Modelling Unbalanced hierarchy

[Ganesh Kedari]

Hello Expertz,

We are facing a issue to create hierarchy where parent values are null for some of the elements.

E.g We have hierarchy as Region>Plant>Unit>Equipment which is working correctly . In some cases we have few equipment at Plant Level so hierarchy as Region>Plant>Equipment

In case of second scenario , in database we have Null at Unit level . When we are publishing package , Region>Plant>Equipment hierarchy does not get rendered.
   
As we need to show complete structure in Tree Prompt , we can not use alternate hierarchy for this issue.
   
Please let me know if you are aware about any work around to create such hierarchy .

[MFGF]

Hi,

Typically you will need to balance your hierarchy in order to get it to behave in the way you desire. This is not just true of DMR - you will find the same issues when trying to use the data in pretty much any OLAP-type environment.

If you happen to have Data Manager, you can use this to deliver a table where the hierarchy is balanced (ie the nulls are removed and replaced with the child member). I guess you don't have this luxury, though?

I would construct a series of calculated items for each "level" that either bring in the stored value from the column or, if the value is null, bring in the child value. Base your DMR levels on these calculated items.

Good luck!

MF.