TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchyTopElementInsertDirect

Available In

TurboIntegrator

Definition

HierarchyTopElementInsertDirect adds a root element to target hierarchy if there isn’t any root element in it. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use HierarchyTopElementInsert.

Syntax

HierarchyTopElementInsertDirect(DimensionNameHierarchyNameInsertionPointElementName); 

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 be direct insert as root element on the dimension

Video Demo

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