Best Practice - HLevel for Alternate Hierarchy

[Former Member]

Good morning,

Our Account dimension contains both a standard and alternate hierarchy. We currently use the HLevel property to drive a variety of formatting (hierarchy indentations, outline for "data bottom", bold for "parent", etc.). The formulas we've developed for the standard hierarchy work well, but they don't always work with the alternate hierarchy. I'm considering the creation of a new "Alt_HLevel" property that would contain the associated numerical hierarchy levels for the alternate. This would provide a level of simplicity in reporting as it would allow us to use consistent formulas. Downside is the added maintenance. Before proceeding, I'd like to know if anyone has a better solution. Thanks!

[Former Member · Accepted solution]

Hi Kim,

As far as my understanding says, HLEVEL will work with the 1st hierarchy of your dimension. So, if you want, you can definitely go ahead by adding another property for the second hierarchy. But yes, as you have already figured out, the cost would be at the maintenance. If you are having regular additions to your dimension, it might be difficult to maintain this property. If the addition of members is not frequent, then I dont see any challenge.

Alternatively, you can try using H2 when you are calling the HLEVEL property. I have never checked this, so not sure whether it will work or not. But worth trying.

Hope this helps.

[Former Member · Accepted solution]

Thanks for your response!