TM1 Function for TI, HierarchyElementInsert

Adds an element to a hierarchy.

What is the HierarchyElementInsert function?

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.

Where can the HierarchyElementInsert function be used?


What is the syntax for HierarchyElementInsert?

HierarchyElementInsert(DimName, HierName, InsertionPoint, ElName, ElType)​;

​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)

A demonstration on how to use HierarchyElementInsert

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