TI Functions

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

Available In



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. 


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.