TI Functions

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(DimensionNameHierarchyNameSubsetName);

HierarchySubsetGetElementName(DimensionNameHierarchyNameSubsetNameElementIndex);

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.