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.