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.
Posted by at
Labels:

17 comments:

  1. Unknown2 August 2016 at 03:51

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

    ReplyDelete
  2. Sumeet Kumar7 August 2016 at 22:55

    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
  3. Gabriel Rearte14 September 2016 at 07:57

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

    ReplyDelete
  4. Sumeet Kumar13 November 2016 at 22:00

    Hi,

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

    ReplyDelete
  5. Unknown19 July 2017 at 12:04

    This code does not work on 10.2.1

    ReplyDelete
  6. Unknown3 September 2017 at 15:57

    hi sumeet,
    I have one question about dashboard. we developed one dashboard and we gave refresh filter button for dashboard. when I click refresh filter button on my dashboard it does not refresh dashboard directly. it goes to database connect and then refresh the dashboard. but I want dashboard refresh directly with out asking data connection. so I need java script for that. can you please give me reply as soon as possible.

    ReplyDelete
    Replies
    1. Sumeet Kumar10 October 2017 at 22:09

      Hi Swathi,

      Whenever you refresh I will fetch the data from DB. It should not ask for data connection if you have only one data connection.

      It seems you have created multiple data connection withing the same data source. Disabling additional data connection will resolve your problem.

      Thanks

      Delete
  7. soumya14 September 2017 at 03:13

    This comment has been removed by a blog administrator.

    ReplyDelete
  8. radha19 July 2018 at 00:19

    Well explained. Keep updating Cognos TM1 online training Hyderabad

    ReplyDelete
  9. sosyal fenomen1 October 2021 at 22:52

    video indir

    cialis

    instagram takipçi satın al

    beğeni satın al

    farmasi üyelik

    bahis forum

    teşekkürler

    ReplyDelete
  10. Anonymous1 May 2022 at 15:04

    mmorpg oyunlar
    instagram takipçi satın al
    tiktok jeton hilesi
    tiktok jeton hilesi
    antalya saç ekimi
    referans kimliği nedir
    instagram takipçi satın al
    metin2 pvp serverlar
    instagram takipçi satın al

    ReplyDelete
  11. Anonymous20 December 2022 at 04:19

    شركة عوازل
    عوازل

    ReplyDelete
  12. mrbahis27 December 2022 at 15:54

    Good content. You write beautiful things.
    sportsbet
    hacklink
    vbet
    vbet
    korsan taksi
    sportsbet
    taksi
    mrbahis
    hacklink

    ReplyDelete
  13. caner9 July 2023 at 11:12

    dijital kartvizit
    referans kimliği nedir
    binance referans kodu
    referans kimliği nedir
    bitcoin nasıl alınır
    resimli magnet
    ZPH7T

    ReplyDelete
  14. buse24 July 2023 at 14:37

    hatay
    kars
    mardin
    samsun
    urfa
    T1E

    ReplyDelete
  15. osman6 September 2023 at 19:46

    arnavutköy
    artvin
    avcılar
    aydın
    bağcılar
    FZS4

    ReplyDelete
  16. Anonymous19 October 2024 at 03:10

    مكافحة حشرات whrNl4oqHe

    ReplyDelete

Subscribe to: Post Comments (Atom)