Cognos IBM Report Studio

CubeDataUpdatedOn Metadata

TIP
Jason Clements
Written by Jason Clements

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.

Procedure

  1. From the Toolbox tab rs_tlbx_tab, drag Layout Calculation to the report.
  2. In the Available Components box, define the calculation:
  • To add functions, summaries, and operators, on the functions tab rs_functions_tab, double-click elements.

3. Click the validate button rs_vldte_fltr.

Tips:

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

Screenshot_17

 

 

Screenshot_16

About the author

Jason Clements

Jason Clements

Who is Jason Clements? Good question. He is a husband, father, BI consultant, and database administrator, He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. Jason is employed with BlueNET Technologies as Senior Business Analytics Consultant.

As an active member of the community, Jason has spoken at regional and local venues including the vendor based trade shows and various user groups & webcasts. He is an active group member and speaker at the North Georgia SQL Server User Group in the ATL area.

Leave a Comment