TM1 Function for TI – HierarchySubsetMDXGet
HierarchySubsetMDXGet returns the MDX expression used to for a subset that’s associated with a hierarchy.
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.
Use HierarchySubsetMDXGet to retrieve the MDX expression for the Department subset that’s associated with the Employee hierarchy and Employee dimension.