TM1 Function for TI, HierarchySubsetExists 

Checks if a public subset exists for a hierarchy.

What is the HierarchySubsetExists function?

HierarchySubsetExists checks if a public subset exists for a hierarchy. 1 is returned if the subset exists or 0 if the subset does not exist.

Where can the HierarchySubsetExists function be used?


What is the syntax for HierarchySubsetExists?

HierarchySubsetExists(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 be checked.​

Note: The subset checked must be public

A demonstration on how to use HierarchySubsetExists

​Use HierarchySubsetExists to check if the Department subset is associated with the Employee hierarchy and Employee dimension.