TI Functions

TM1 Function for TI – ​​​​​​​​​​​HierarchyElementInsert

Available In



HierarchyElementInsert adds an element to a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementInsertDirect.



DimName = Dimension Name

HierName = Hierarchy Name

InsertionPoint = An existing element where the element is inserted before this element. If blank, the new element will be added as the last element in the dimension.

ElName = Element Name

ElType = Element type (N for numeric element, S for string element and C for consolidated element)

Video Demo

Add Scotland as a numeric element, positioned before Wales, element in the United Kingdom hierarchy from the Sales Region dimension.