TM1 Function for TI, HierarchyTimeLastUpdated
Returns a number which refers to the last time the hierarchy was updated.
What is the HierarchyTimeLastUpdated function?
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.
Where can the HierarchyTimeLastUpdated function be used?
TurboIntegrator
What is the syntax for HierarchyTimeLastUpdated?
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
A demonstration on how to use HierarchyTimeLastUpdated
Use HierarchyTimeLastUpdated to retrieve the date number when the
Employee Hierarchies’ hierarchy and ‘Employee Hierarchies’ dimension was last updated.