Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Automatic refresh on Dashboard

    Posted Thu February 21, 2019 11:35 AM
    ​Hi,

    Cognos Analytics 11.1

    I have developed sql code to update a SQL Server table every 5 seconds and have built a dashboard over this table.  The dashboard data comes from a data module that is connected to a SQL Server database and the data is coming across without any issue.

    I have set the dashboard to refresh automatically every 5 seconds but the graph on the dashboard is not updating.

    I have tried several different visualisations and none of these seem to work.

    I have turned off cache in the dashboard and in the data module but to no avail.

    I am using Chrome but have also tried Internet Explorer 11 and neither work.

    I am keen to demo a graph updating to my Deputy CEO next week as realtime reporting is on the agenda.

    There still seems to be caching going on somewhere else but I cannot find where it is.  Can you please advise.

    Kind regards,

    Kirk

    ------------------------------
    Kirk Lothian
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Automatic refresh on Dashboard

    Posted Sat February 02, 2019 01:46 PM
    @Kirk Lothian

    We fixed an issue in this area. Not sure if you come across the same issue. You may not be using the latest kit that contains the fix. Can you give me the full version of your CA server? 

    You can find the version in installDir/cmplst.txt.  Look for "Manifest=casrv-manifest-11.1.x-xxxxxxxxxx"

    ------------------------------
    KIAN GOH
    ------------------------------

    Original Message


  • 3.  RE: Automatic refresh on Dashboard

    Posted Sun February 03, 2019 06:10 AM
    Hi Kian,

    Thank you for you prompt reply.  In answer to your question the version we are running is below.

    Manifest=casrv-manifest-11.1.1-1811151250-winx64h.json

    Kind regards,

    Kirk​

    ------------------------------
    Kirk Lothian
    ------------------------------

    Original Message


  • 4.  RE: Automatic refresh on Dashboard

    Posted Sun February 03, 2019 10:34 PM
    @Kirk Lothian

    It is confirmed the version you have does not contain the fix to the cache issue. You need version 11.1.1-1812041507 or later.

    Please download the latest version or contact support for assistance.

    ------------------------------
    KIAN GOH
    ------------------------------

    Original Message


  • 5.  RE: Automatic refresh on Dashboard

    This message was posted by a user wishing to remain anonymous
    Posted Mon February 04, 2019 03:44 AM
    This message was posted by a user wishing to remain anonymous

    Hi Kain,

    Sincere thanks for your help.  We are working on this now.  Have a great day!

    Kind regards,

    Kirk​
    Original Message


  • 6.  RE: Automatic refresh on Dashboard

    Posted Fri February 08, 2019 02:46 AM
      |   view attached
    Hi,

    After installing the latest fix pack my issue was not resolved.  I kept investigating and found the source of the issue.  There is a 3rd area where the data is cached.​  When I set the database cache to "None" within the data module the automatic refresh worked perfectly.

    However, I have not been using the 11.1 version long enough to understand what performance impact removing the cache may have.  For the meantime I will process with this config.

    I have attached a screenshot for reference.

    Kind regards,

    Kirk

    ------------------------------
    Kirk Lothian
    ------------------------------

    Original Message


  • 7.  RE: Automatic refresh on Dashboard

    Posted Fri February 08, 2019 01:52 PM
    @Kirk Lothian

    There are cache controls at Dashboard level as well as Data Module level. ​It is a design intent to set cache at 3600 seconds in Data Module at default. 

    Glad to hear that you've picked up the latest kit. You will need that fix for the cache to work correctly in Dashboard.

    ------------------------------
    KIAN GOH
    ------------------------------

    Original Message