I would like to know, how does Qlickview work with unbalanced hierarchies.
Hierarchies in wich branches of the hierarchy descend to different levels.
For example, an Organization dimension contains a member for each employee in a company. The CEO is the top member in the hierarchy, and the division managers and executive secretary are immediately beneath the CEO. The division managers have subordinate members but the executive secretary does not.
Which is th best way to deal with this hierarchies, definng it in the escript editor??. In Business Objects or Microstrategy I have resolved rgis issue repeting the same value in various members in the branch who has less levels.
Any advice to work with this kind of hierarchies will be greaty aprecitted.