Rule Functions

TM1 Function for Rules – HIERARCHY 

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.