Returns the number of elements in a subset that’s associated with a hierarchy.
What is the HierarchySubsetGetSize function?
HierarchySubsetGetSize returns the number of elements in a subset that’s associated with a hierarchy.
Where can the HierarchySubsetGetSize function be used?
TurboIntegrator
What is the syntax for HierarchySubsetGetSize?
HierarchySubsetGetSize(DimensionName, HierarchyName, SubsetName);
DimensionName = Name of the dimension the subset is in.
HierarchyName = Name of the Hierarchy the subset is in.
SubsetName = Name of the subset to be checked.
A demonstration on how to use HierarchySubsetGetSize
Use HierarchySubsetGetSize to retrieve the number of elements 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