Adds an element to a hierarchy.
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.
TurboIntegrator
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)
Add Scotland as a numeric element, positioned before Wales, element in the United Kingdom hierarchy from the Sales Region 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