Display last refresh date and time - Cognos 8.3 cubes

[paulami]

Hi,

   How do I display the last refresh date and time of cognos cubes.

   Cognos Version 8.3

Thanks,
Paulami

[proud2bloud]

Hi there
You can do this in 8.4 Report Studio using the built in functions under report functions.

You can also create a custom measure in your cube and set it to today(). You can then publish the cube and query it through there. 

What you also need to think about is the value behind providing that information to the users. In our case, the cubes are refreshed every month but the data does not change every month. The cube refresh date will give the users the impression that the data is not that old whereas it really is older. Just wanted to add my 10 cents worth.

Cheers
Proud