TM1 Function for TI – HierarchyTopElementInsert

TM1 Function for TI, HierarchyTopElementInsert

Adds a root element to a hierarchy, if there isn’t any root element in it.

What is the HierarchyTopElementInsert function?

HierarchyTopElementInsert adds a root element to a hierarchy, if there isn’t any root element in it. 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 HierarchyTopElementInsertDirect.

Where can the HierarchyTopElementInsert function be used?

TurboIntegrator

What is the syntax for HierarchyTopElementInsert?

HierarchyTopElementInsert(DimensionName, HierarchyName, InsertionPoint, ElementName);

DimensionName = Name of the dimension to insert a top element.
HierarchyName = Name of the Hierarchy to insert a top element.
InsertionPoint = Position to add top element inside the hierarchy.
ElementName = Name of the element to insert as root element on the dimension.

A demonstration on how to use HierarchyTopElementInsert

Use HierarchyTopElementInsert to insert the element, Total Customer, to position 1 in the Customer dimension.