TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchySubsetElementInsert

Available In



HierarchySubsetElementInsert adds an element into a subset associated to a hierarchy.


HierarchySubsetElementInsert(DimensionNameHierarchyNameSubsetNameElementName, Position);

 DimensionName = Name of the dimension the subset is made of.

HierarchyName = Name of the Hierarchy the subset is made of.

SubsetName = Name of the subset the element will be added in.

ElementName = Name of the element to insert in the existing subset.

Position = Position Index Number inside the subset which the element will be insert.

Note: The subset must be public

Video Demo

Use HierarchySubsetElementInsert to insert Finance into the 5th position in the Departments subset that’s associated with the Employee hierarchy and Employee dimension.