Cognos Analytics

 View Only
  • 1.  How to Refresh reports in Cognos Analytics

    Posted Fri June 07, 2019 10:08 AM
    How to refresh reports in Cognos Analytics when Source  file( excel or CSV ) data gets refreshed .

    ------------------------------
    MONA KEDIA
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to Refresh reports in Cognos Analytics

    Posted Fri June 07, 2019 01:06 PM
    ​you can refer below ibm link for more details

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cxc.10.2.2.doc/c_coc_gt_strtd_refreshdata.html

    ------------------------------
    Babu Periassamy
    ------------------------------



  • 3.  RE: How to Refresh reports in Cognos Analytics

    Posted Sun June 09, 2019 05:59 PM
    You don't mention what version of CA you are using and in what context.
    The link from Babu is valid for Cognos for Microsoft Office.

    Here is a newer link for that:

    https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cxc.doc/c_coc_gt_strtd_refreshdata.html

    If you are using Cognos for Microsoft Office that should be sufficient.

    If you are using uploaded files in Cognos Analytics then the process should be a bit simpler.

    If you have changed the metadata of the file or any module which consumes the file and then is used in a report, then it could be necessary to update the report.

    If you have not changed the metadata but only added data to the file then the report or dashboard should automatically pick up the new data and not require any additional actions.  There could be data cache latency.

    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 4.  RE: How to Refresh reports in Cognos Analytics

    Posted Mon June 10, 2019 06:05 AM
    Thanks that was of really help.

    I had another query, With the data refresh I want to do w2w comparison .. So is it possible to get the data refresh and at same time I do the week to week comparison.Attaching the screen shot .

     In the below table, I want  A, B , C and D data to get refresh every week from flat excel file and  W2W comparison with the previous week data.

    Currently exploring Cognos Analytic 11.1 version
    Cognos query

    ------------------------------
    MONA KEDIA
    ------------------------------