Planning Analytics with Watson

 View Only
Expand all | Collapse all

Report refresh in PAfE takes a long time

  • 1.  Report refresh in PAfE takes a long time

    Posted Tue November 08, 2022 06:53 PM

    Hi,

    One of our small report files (817 KB), with DBRW formulas, takes 5 to 10 minutes to refresh in PAfE. With ISB, it refreshes within 10 seconds. Can you please suggest any tips/ideas for speeding refresh time in PAfE.

    Thank you.



    ------------------------------
    Vincent George
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Report refresh in PAfE takes a long time

    IBM Champion
    Posted Wed November 09, 2022 01:00 AM
    Does your report have volatile functions? This caught me early on with PAfE.

    https://learn.microsoft.com/en-us/office/client-developer/excel/excel-recalculation

    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------



  • 3.  RE: Report refresh in PAfE takes a long time

    Posted Wed November 09, 2022 12:22 PM
    Hi George,

    Thank you very much for your response and this great tip, and also the link to Microsoft help site. I shall do some testing based on this help document.

    There are no highly volatile functions like dates, but the file has links to a small parameter sheet for selecting year, period and reporting unit. Also the file pulls data for multiple years and months. There are only about 600 lines, and we have had no issues refreshing much larger files designed in a similar way. However, I'll take a closer look on the formulas based on your suggestion.

    Thank you again for your help.
    Vincent

    ------------------------------
    Vincent George
    ------------------------------



  • 4.  RE: Report refresh in PAfE takes a long time

    Posted Thu November 10, 2022 02:22 AM
    Hi Vincent,

    Recently i observed few pafe reports taking longer or not refreshing. while they worked fine on perspective. Upon enabling debug logs i found out there were elements in the reports which referenced to values not in dimensions. eg some versions which are now deleted. while perspective would just skip over and show the value of cells without issues, pafe is more sensitive. something you may want to try.

    thanks
    Saurabh

    ------------------------------
    Saurabh Dwivedi
    ------------------------------



  • 5.  RE: Report refresh in PAfE takes a long time

    Posted Mon November 14, 2022 05:25 PM

    Exploration Reports is most comparable to ISB, I'm curious about the performance there.

    Putting that aside, there's a variety of techniques to profile workbook performance. many good ideas already in the thread here, but my addition would be to run the application at 'all' level logging and the log+har material can be reviewed to make it evident where the delay is happening or if it's evenly spread across the workload.

    I would be fairly optimistic based on your remarks that there a likely some low-hanging improvements to be had via configuration. Interested to hear more.



    ------------------------------
    Ted Phillips
    IBM
    ------------------------------



  • 6.  RE: Report refresh in PAfE takes a long time

    Posted Tue November 15, 2022 04:25 PM

    Hi Saurabh,

    Thank you for your response. Yes, we are aware of the sensitive nature of PAfE, and this report has no invalid elements. We'll do some further testing.

    Thank you.

    Vincent



    ------------------------------
    Vincent George
    ------------------------------



  • 7.  RE: Report refresh in PAfE takes a long time

    Posted Tue November 15, 2022 04:39 PM