Hierarchy Rules Functions

Functions to manage hierarchies in rules.

Hierarchy
If there is only one hierarchy included in the supplied dimension, Hierarchy returns the name of the hierarchy. Otherwise, it returns an empty string. Hierarchy is valid in rules only.
HierarchyCount
HierarchyCount returns the number of hierarchies in the supplied dimension. HierarchyCount is valid in rules only.
HierarchyIndex
HierarchyIndex returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise. HierarchyIndex is valid in rules only.
HierarchyN
HierarchyN returns the name of the hierarchy at a specified position in the supplied dimension and an empty string if the index is out of scope. HierarchyN is valid in rules only.

Parent topic: Rules functions