TM1 Function for TI, HierarchySubsetElementInsert

Adds an element into a subset associated to a hierarchy.

What is the HierarchySubsetElementInsert function?

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

Where can the HierarchySubsetElementInsert function be used?


What is the syntax for HierarchySubsetElementInsert?

HierarchySubsetElementInsert(DimensionName,¬†HierarchyName,¬†SubsetName,¬†ElementName, 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

A demonstration on how to use HierarchySubsetElementInsert

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