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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book