HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
Where can the HIERARCHY function be used?
Rules
What is the HIERARCHY function?
HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
What is the syntax for HIERARCHY?
Hierarchy (DimName);
DimName = Dimension name.
A demonstration on how to use HIERARCHY
Use Hierarchy function to retrieve Employee Hierarchies dimension hierarchy name and apply it in the rule to populate in the Employee Salaries cube.
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