HIERARCHYINDEX function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
Where can the HIERARCHYINDEX function be used?
Rules
What is the HIERARCHYINDEX function?
HIERARCHYINDEX function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
What is the syntax for HIERARCHYINDEX?
HierarchyIndex(DimName, HierName);
DimName = Dimension name.
HierName = A valid hierarchy name.
A demonstration on how to use HIERARCHYINDEX
Use HierarchyIndex function to retrieve dimension hierarchy index value 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