HierarchyTimeLastUpdated
HierarchyTimeLastUpdated indicates when a specified dimension hierarchy was last updated. The function returns a real number that represents the current day (including the hour, minute, second, and millisecond) since the beginning of the year 1900.
This function is valid in TM1® TurboIntegrator processes only.
Syntax
HierarchyTimeLastUpdated(dimension, hierarchy);
Argument |
Description |
---|---|
dimension |
The name of the dimension. |
hierarchy |
The name of the hierarchy. |
Example
HierarchyTimeLastUpdated('Region', 'Europe');
This example returns information on when the Europe hierarchy of the Region dimension was last updated. If a value of 42548.<hours>.<minutes>.<milliseconds> is returned, you can divide 42548 by 365 to obtain (approximately) 116. When added to the started of 1900, the result is a current year of 2016.