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.
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.