CubeTimeLastUpdated
CubeTimeLastUpdated returns a serial value that indicates the date and time at which a specified cube was last updated.
The serial value that is 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 and time serial values are stored and reported in Microsoft Excel.
Note: By default, TM1® date and 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
and time serial values, you can set UseExcelSerialDate=T in your Tm1s.cfg file
to instruct the TM1 server to use date and time serial values that conform to Excel
standards.
This function is valid in TM1 TurboIntegrator processes only.
Syntax
CubeTimeLastUpdated(cube);|
Argument |
Description |
|---|---|
|
cube |
The name of the cube. |
Example
CubeTimeLastUpdated('Sales');This example returns a value corresponding to the time when the Sales cube was last updated.