HIERARCHYINDEX function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
Where can the HIERARCHYINDEX function be used?
規則
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.
