What is the HierarchySubsetMDXGet function?
HierarchySubsetMDXGet returns the MDX expression used to for a subset that’s associated with a hierarchy.
Where can the HierarchySubsetMDXGet function be used?
TurboIntegrator
What is the syntax for HierarchySubsetMDXGet?
HierarchySubsetMDXGet(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 retrieve the MDX expression.
A demonstration on how to use HierarchySubsetMDXGet
Use HierarchySubsetMDXGet to retrieve the MDX expression for the Department 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