TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​HierarchyTimeLastUpdated

Available In

TurboIntegrator

Definition

HierarchyTimeLastUpdated returns a number which refers to the last time the hierarchy was updated. This is a consecutive number that counts the days since 01/01/1900. 

Syntax

HierarchyTimeLastUpdated(Dimension, Hierarchy);​

DimensionName = Name of the dimension to check.​

HierarchyName = Name of the Hierarchy to check.​

Note: This is NOT the date serial number used on other functions​

Video Demo

Use HierarchyTimeLastUpdated to retrieve the date number when the Employee Hierarchies hierarchy and Employee Hierarchies dimension was last updated.​

​