If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Displaying last cube update date and time in Reporting

Started by Thunder, 01 Feb 2018 08:34:53 AM

Previous topic - Next topic

Thunder

For customers who are using Powerplay cubes, is there a way to display the last MDC file update date and time in Reporting?  We are able to do so in Powerplay Studio but want to migrate away from Powerplay Studio to Reporting in Cognos 11.   We need to display the last update date and time in the header of the report but want this to be generic just based on the cube data source we are using and not have to supply a cube name or dimension to a function.

MFGF

Quote from: Thunder on 01 Feb 2018 08:34:53 AM
For customers who are using Powerplay cubes, is there a way to display the last MDC file update date and time in Reporting?  We are able to do so in Powerplay Studio but want to migrate away from Powerplay Studio to Reporting in Cognos 11.   We need to display the last update date and time in the header of the report but want this to be generic just based on the cube data source we are using and not have to supply a cube name or dimension to a function.

Hi,

The only solution I can think of is to use a Layout Calculation with the CubeDataUpdatedOn (<dimension>) function. You can't do it without bringing in a dimension of the cube you want to use, though - packages can support multiple cubes and multiple data sources, so you need to tell it which cube to go looking at.

Cheers!

MF.
Meep!