Cognos Analytics

 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