Thursday, 30 October 2014

Cognos: Auto Refresh Dashboard

Recently I developed a Cognos dashboard which gets refreshed after fixed time interval automatically. This can be achieved easly by using a simple script. Here are the steps:

-Insert a HTML item with below script

    <meta http-equiv="refresh" content="60">

-Select the query and set the "Use Local Cache" property to "No".
-Go to Cognos Connection
-Click report property and set the default action to "Run the Report" under Report tab.
-Run the report. You will see the report get refreshed after each 1 minute interval.

5 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. The above technique is not working in Cognos8. Can you please elaborate.

    ReplyDelete
  3. Hi Brijesh,

    I have tested this code in Cognso10. Just follow the steps and run the report from Cognos Connection. It should work.

    Thanks

    ReplyDelete
  4. Hi Summet! this technique, is not work on Cognos10, with a report on a Prompt select, you have any idea for why?

    ReplyDelete
  5. Hi,

    This code will work with the default prompt selection as it execute the report every time.

    ReplyDelete