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 28 days ago

    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
    ------------------------------


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

    Posted 28 days ago
    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 28 days ago
    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 27 days ago
    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 22 days ago

    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 21 days ago

    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 21 days ago

    Hi Ted,

    Thank you for your response.

    Since the report is a template that would be used by several users in multiple countries (whose data is sitting in different cubes), creating such a report using Exploration or Quick is not easily doable. Custom report is the most suitable in this scenario.

    We shall try to do the logging you had suggested and see if we get anywhere with the findings. While these experiments can take some time to find the root cause, it is much easier to run the report in ISB that will do the trick under 10 seconds ;)

    Thank you.

    Vincent



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



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

    InnerCircle
    Posted 13 days ago