TM1 Function for TI – HierarchySubsetGetElementName
Available In
TurboIntegrator
Definition
HierarchySubsetGetElementName returns the name of an element from a subset using an index number that’s associated with a hierarchy.
Syntax
HierarchySubsetExists(DimensionName, HierarchyName, SubsetName);
HierarchySubsetGetElementName(DimensionName, HierarchyName, SubsetName, ElementIndex);
DimensionName = Name of the dimension the subset is in.
HierarchyName = Name of the Hierarchy the subset is in.
SubsetName = Name of the subset the element is insert.
ElementIndex = Position of the element inside the subset which you want to retrieve the name.
Video Demo
Use HierarchySubsetGetElementName to retrieve the 5th element from the Departments subset that’s associated with the Employee hierarchy and Employee dimension.