TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchySubsetElementDelete 

Available In



HierarchySubsetElementDelete deletes an element from a subset using an index number.


HierarchySubsetElementDelete(DimensionNameHierarchyNameSubsetName, Index);

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 in.

Index = Index number of the element to be deleted from a subset.

Video Demo

Use HierarchySubsetElementDelete to delete the 5th element in the Department subset associated with the Employee hierarchy and Employee dimension.