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