Where is 'Cube Updated' info?

[mce]

Hi All,

When looking at TM1 cubes via Cognos 8 Analysis Studio, you have the option of displaying the time that the TM1 cubes is last updated in the header of the report. Does anyone know where this information is stored in TM1? and can we access to this information from within a TI process?

Thanks in advance for any comments.

Regards,

[mce]

Cognos 8 is using the following command for this:

Code: Select all

CubeDataUpdatedOn([cube_name].[time_dimension_name])

but there is no such information in cube properties cube.

[David Usherwood]

Interesting.
Does it work? ie when you change data in a cube, does the datetime stamp change in BI?
And if so, what happens about rule based, dependent values?

[mce]

It shows the last time that the attributes of the time dimension has changed.
So that means it is not working properly for the cube.
But, if you also update an attribute in your time dimension when you update data in the cube, then it can serve the requirement as a work around.

[tomok]

It shows the last time that the attributes of the time dimension has changed.

It probably is keying off the LAST_TIME_UPDATED value in the }DimensionProperties cube. That key is there because the replication and synchronization routines need it to know whether a dimension needs to be updated on the planets. Your assertion that it changes when attributes change is only partially correct however. If you add or delete an attribute the LAST_TIME_UPDATED value in the }DimensionProperties cube changes. If you just change the value of an existing attribute it does not.

[mce]

It probably is keying off the LAST_TIME_UPDATED value in the }DimensionProperties cube.

I do not think so. the value in that field in dimension properties cube is different than what is displayed in the report. But when I checked the tm1serverlogs, I realized that the time that is shown in the report is exactly the same time that the last attribute changed to the time dimension is committed (end of epilog).