BusinessObjects Board

Report performance Tuning

building reports desktopintelligence
#1

Hi all,

I am new to BO, I just want to know the best ways to tune the performance of the report and it would be more helpful if someone can guide me , how BO generated SQL can be tuned .

Thank you,

Raj

rajchowdary81 (BOB member since 2007-02-01)

Performance tuning.
#2

Performance Tuning:
Do not use constant values in the report.
Organize your query well
Know the db structure to best design the query.
Do not refresh every report on open or so, do it as per requirement.

ferozster :india: (BOB member since 2007-06-14)

#3

A few pointers:-

Report

Try to make sure you where clauses constrain on integers in the where clause, if possible, you can use Index Awareness in Designer for this.

Try and produce your reports with as few data providers as possible.

Remove unused formule, they should, ideally all be variables.

Database

Try and resolve complex calculations using your ETL, rather than calculate at run time, using Business Objects.

Try to use properly indexed tables or material views rather than derived table or standard views.

You should analyse the query using a SQL editor, e.g. Explain Plan for Oracle.

You should then provide indexing on the database and hints in Designer as required.

Mak 1 :uk: (BOB member since 2005-01-06)

#4

Thanks Mak, for putting more light.

ferozster :india: (BOB member since 2007-06-14)

#5

Please, have a look at the Reporter FAQ here.

Andreas :de: (BOB member since 2002-06-20)

#6

could you please elaborate on this.

Thanks.

lahca_ac (BOB member since 2010-01-18)

#7

Does that mean if i rearrange objects there in where clause, will that affect ?
e.g. right now i’m filtering out with not inlist some id’s then ANDed with year filter which is for 2 years then again some filter followed by various dimensions with or/and…
would that really matter and how, please let me know.

Thanks

lahca_ac (BOB member since 2010-01-18)