HIERARCHYINDEX function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
Where can the HIERARCHYINDEX function be used?
Zasady
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.
Zobacz jak Cubewise może ci pomóc
Chętnie pokażemy ci, jak zestaw aplikacji może pomóc lepiej prognozować, budżetować i planować.
Książka
