TM1 Function for Rules, HIERARCHY
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
Which TM1 Server version is this function available for?
Version 11 and 12
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.