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