I am testing reports in the DEV environment before moving to PROD, and noticed that out of a total population of 10 reports, 2 are rendering particularly slowly. They are taking just over 3 MINUTES to render. Is there a specific cause that I should focus on first from a trouble shooting standpoint within these reports?
Thanks, John for those suggestions! I compared the data query optimization options between the reports in FR Studio, and they were all consistent.
But, how do I check if it is the Essbase query or the report generation that is taking the time?
You could try different settings in the optimization options, when you run the report you should be able to check the essbase application log to see how long the retrieveal from the report take.