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. 

Available In

Rules

Definition

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.  

Syntax

Hierarchy (DimName);

DimName =  Dimension name.

Video Demo

Use Hierarchy function to retrieve Employee Hierarchies dimension hierarchy name and apply it in the rule to populate in the Employee Salaries cube.