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?


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.