In cases where a Cognos report is to be used as a dashboard, an auto refresh capability in the report is required to load the data automatically at specific intervals without human intervention.
Following are the high level instructions on how to achieve it. A link to the detailed document is provided below.
- For all the queries in the report, set the property Use Local Cache to No.
- Add a HTML item at the top of the report and add the following meta tag in it.
<meta http-equiv="refresh" content="5">
This will refresh the report every 5 seconds. Content attribute is in seconds. You cn set it as per your requirement
- If you have loaded the Cognos report into a Tivoli Integrated Portal dashboard, then set the session timeout value to not expire for the application server on which Tivoli Common Reporting is running.
For more details, download the document 'Cognos Report in Dashboard'.