TM1 Function for TI – HierarchySubsetMDXGet
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
Which TM1 Server version is this function available for?
Version 11 and 12
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.