Have you ever need to display the Cubes last data updated? Well there is a way to do that. Add a Layout calculation within the report and use the report function to get this information. I have tested it with IBM PowerCubes and Microsoft SSAS Cubes.
The report function is called CubeDataUpdatedOn ( dimension )
Returns the date time that data in the cube was last updated. “Dimension” specifies from which cube to retrieve the metadata.
- From the Toolbox tab , drag Layout Calculation to the report.
- In the Available Components box, define the calculation:
- You can also type the calculation directly in the Expression Definition box.
- You can also add a text box to describe what you are displaying. See example below.