TM1 Function for TI, HierarchySubsetGetElementName
Returns the name of an element from a subset using an index number that’s associated with a hierarchy.
What is the HierarchySubsetGetElementName function?
HierarchySubsetGetElementName returns the name of an element from a subset using an index number that’s associated with a hierarchy.
Where can the HierarchySubsetGetElementName function be used?
What is the syntax for HierarchySubsetGetElementName?
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.
A demonstration on how to use HierarchySubsetGetElementName
Use HierarchySubsetGetElementName to retrieve the 5th element from the Departments subset that’s associated with the Employee hierarchy and Employee dimension.