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?
TurboIntegrator
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.