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?


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.