Improve Performance of report any suggestions

system · July 16, 2008, 6:23pm

Hi

I am testing the performance of a Report it has 8 tabs quarterly gross and net,monthly gross and net and 14 drill filters . Is there any way i can improve its performance like a deski solution, any other way in webi i can do that anything will help guys.

johnedward (BOB member since 2008-04-04)

system · July 16, 2008, 7:22pm

change the columns width to fix number, any iterative formulas convert to variables, try to reduce the number of queries, complex calculations try to move to the database.

Marfi (BOB member since 2006-12-18)

system · July 16, 2008, 10:15pm

Hi,
Are you concerned with the database performance like the time in which the date should be retreived.

because performance of the report may depend upon time taken to refresh the report as well.

Omkar Paranjpe (BOB member since 2006-02-13)

system · July 17, 2008, 5:24am

Also do try to do the calculations at the universe level itself.

Clean up your report by deleting the unused formulas and variables if any.

Jansi (BOB member since 2008-05-12)

system · July 17, 2008, 5:46am

Report performance can be categorized in a number of sections as:

Database Query response time.
Online formulae calculations time on the Webi Report server.
The delay between fetching the records from the DB server to the Web Server

Check the chances for query optimization by seeing the query generated, your DBA will help you in the Execution plan.

krish007 (BOB member since 2006-10-06)

system · July 17, 2008, 6:02am

Please, see this oldie but goldie FAQ entry Why is my report so slow.

Andreas (BOB member since 2002-06-20)