Adds a root element to a hierarchy, if there isn't any root element in it.
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.
TurboIntegrator
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.
Use HierarchyTopElementInsert to insert the element, Total Customer, to position 1 in the Customer dimension.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book