TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchySubsetMDXGet

Available In

TurboIntegrator

Definition

HierarchySubsetMDXGet returns the MDX expression used to for a subset that’s associated with a hierarchy.

Syntax

HierarchySubsetMDXGet(DimensionNameHierarchyNameSubsetName);

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.

Video Demo

Use HierarchySubsetMDXGet to retrieve the MDX expression for the Department subset that’s associated with the Employee hierarchy and Employee dimension.