Hi,
There is nothing much (esp. in your case where the report time 60 mins.) that you can do at BO level to improve the performance or tune the report.
You need to check the performance of the queries built by your DPs in the back end. If needed tune these queries by various ways (indexing etc.)
Have you searched before posting, there lots of threads on the same topic which might have given you some idea. Here are few to proceed with:
Hi,
I have build a report which has two dataproviders. When I run it it takes a very long time to refresh. Most of the time it looks like nothing happens (no messages in status bar) and I’m looking at an hourglass. Is this the time that the query is running? The report is quit complex, I would like to know which part of the time of refresh is query-time and which part report-calculation/formatting time. So I know if I should make the report less complex or the query. Is it correct that when in …
Hi,
I have created one report, it contains only 3 dimensions and one measure. The details are also very less.
My DB and check integrity functions also perfectly ok. But it is very slow?
How to do increse the performance?.
Thanks,
thangavelu (BOB member since 2004-12-14)
Here is an entry from Reporter FAQ:
Why is my report so slow?
Submitted by kmahler, additional comments by Andreas (July 2009).
What makes up the total time a report runs from hitting the Refresh button to being displayed:
Query execution time (database side)
Transferring results across the network to the client/web browser (network bandwidth & latency)
Computing local report variables, formulas, local report filters, alerters, etc. within the report (BOE server/ DesktopIntelligence workstation)
Rendering the page (pag…
Hope this helps.
ravi.
palepuravi (BOB member since 2003-10-28)