DimensionTimeLastUpdated
DimensionTimeLastUpdated returns a serial value that indicates the date and time at which a specified dimension was last updated.
The serial value returned by this function uses a starting time of Jan 1 1900 12:00:00 A.M., which is equivalent to the value 1.0. Dates are represented by integers, while times are represented as decimal numbers between .0 and .999999. This is consistent with the way date/time serial values are stored and reported in Microsoft Excel.
Note: By default, TM1® date/time serial values use a starting
time of Jan 1 1960 12:00:00 A.M. To resolve the inconsistency between Excel and TM1 date/time serial
values, you can set
UseExcelSerialDate=T in your Tm1s.cfg file to instruct the TM1
server to use date/time serial values that conform to Excel standards.This function is valid in TM1 TurboIntegrator processes only.
Syntax
DimensionTimeLastUpdated(dimension);|
Argument |
Description |
|---|---|
|
dimension |
The name of the dimension. |
Example
DimensionTimeLastUpdated('Region');This example returns information on when the Region dimension was last updated.