Adds an element into a subset associated to a hierarchy.
HierarchySubsetElementInsert adds an element into a subset associated to a hierarchy.
HierarchySubsetElementInsert(DimensionName, HierarchyName, SubsetName, ElementName, Position);
DimensionName = Name of the dimension the subset is made of.
HierarchyName = Name of the Hierarchy the subset is made of.
SubsetName = Name of the subset the element will be added in.
ElementName = Name of the element to insert in the existing subset.
Position = Position Index Number inside the subset which the element will be insert.
Note: The subset must be public
Use HierarchySubsetElementInsert to insert Finance into the 5th position in the Departments subset that’s associated with the Employee hierarchy and Employee 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