Cognos Analytics with Watson

 View Only
  • 1.  Data Set Refresh Time

    Posted Fri June 17, 2022 10:49 AM
    Hi,
    I am using a couple of data sets behind some reports.  A database view is the source to those data sets.

    The data sets have scheduled to refresh every day in the morning.  The below fig 1 is the snap shot of the data sets run time part of a scheduled job.  It shows a data set takes time around 10 minutes and other one does 12 minutes.  Whereas fig 2 shows actual time taken to refresh each data set thru its properties.  They show max 4 minutes.  In this case, why does the schedule always takes around 12 minutes to complete?  Is there any other factor for the cause ?  Could anyone help me to understand?

    Please let me know if you have any questions.


    Fig. 1


    Fig. 2


    Thanks
    Regards,
    Karthik

    ------------------------------
    Karthikeyan Balasubramaniam
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Set Refresh Time

    InnerCircle
    Posted Tue November 15, 2022 09:48 AM
    Hi,

    We have similar observation in our Cognos Analytics 11.1.7 environment. Did anyone come across an explanation for this?

    Thanks in advance.


    Regards,
    Pradeep

    ------------------------------
    Pradeep Chaluvaiah
    ------------------------------



  • 3.  RE: Data Set Refresh Time

    IBM Champion
    Posted Fri November 18, 2022 03:59 AM
    Hi Karthikeyan,

    If you are having such issues, I would suggest you open a support call if you haven't already, they would help you to find a real explanation about this issue.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------