HIERARCHYN returns the name of the hierarchy at a specified position.
Where can the HIERARCHYN function be used?
Rules
What is the HIERARCHYN function?
HIERARCHYN returns the name of the hierarchy at a specified position.
What is the syntax for HIERARCHYN?
HierarchyN(DimName, Index);
DimName = Dimension name.
Index = A value less than or equal to the number of hierarchies in the dimension.
A demonstration on how to use HIERARCHYN
Use HierarchyN function to retrieve Employee Hierarchies dimension hierarchies name and apply it in the rule to populate in the Employee Salaries cube.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book