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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book