TM1 Function for TI, HierarchyExists
Checks whether a specific hierarchy exists in a dimension.
What is the HierarchyExists function?
HierarchyExists checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1 and if it does not exist the result is 0.
Where can the HierarchyExists function be used?
TurboIntegrator
What is the syntax for HierarchyExists?
HierarchyExists(DimName, HierName);
DimName = Dimension Name
HierName = Element Name
A demonstration on how to use HierarchyExists
Check whether the United Kingdom hierarchy exists in Sales Region dimension.