Page 1 of 1
Where is 'Cube Updated' info?
Posted: Thu Jun 16, 2011 12:12 pm
by 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,
Re: Where is 'Cube Updated' info?
Posted: Thu Jun 16, 2011 12:28 pm
by 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.
Re: Where is 'Cube Updated' info?
Posted: Thu Jun 16, 2011 12:54 pm
by 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?
Re: Where is 'Cube Updated' info?
Posted: Thu Jun 16, 2011 1:07 pm
by 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.
Re: Where is 'Cube Updated' info?
Posted: Thu Jun 16, 2011 3:05 pm
by tomok
mce wrote: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.
Re: Where is 'Cube Updated' info?
Posted: Fri Jun 17, 2011 9:06 am
by mce
tomok wrote: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).