Returns the name of an element from a subset using an index number that’s associated with a hierarchy.
HierarchySubsetGetElementName returns the name of an element from a subset using an index number that’s associated with a hierarchy.
HierarchySubsetExists(DimensionName, HierarchyName, SubsetName);
HierarchySubsetGetElementName(DimensionName, HierarchyName, SubsetName, ElementIndex);
DimensionName = Name of the dimension the subset is in.
HierarchyName = Name of the Hierarchy the subset is in.
SubsetName = Name of the subset the element is insert.
ElementIndex = Position of the element inside the subset which you want to retrieve the name.
Use HierarchySubsetGetElementName to retrieve the 5th element from 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