Adds a root element to target hierarchy if there isn’t any root element in it.
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.
HierarchyTopElementInsertDirect(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 be direct insert as root element on the dimension
Use HierarchyTopElementInsertDirect to insert the element, Total Customer, in the Customer dimension to position 1.
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