BusinessObjects Board

Performance tuning of DeskI reports

building reports desktopintelligence
#1

How can we improve the performance tuning of Desk top Intelligence reports in BusinessObjects?

Rajun (BOB member since 2007-12-08)

#2

You can do lots of things.

  1. Modify the SQL by adding hints.
  2. Build aggregates in your universe.
  3. Use index awareness in the universe
  4. Use derived tables in the universe

But, the real question doesn’t make sense. You don’t tune reports. You can do a little tuning on a universe. But, you really tune databases. You may need indexes, statistics or other things that will make your database faster.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

Hi Rajun,
As mentioned by Steve, it will be nice if you tune the query at the database level. I mean, whne you need good performance, ou have to have a look at the query which ie being formed by the SQL engine of BO.

You can think on the following points also.

  1. Try to see you have index on the objects which are present in the where clause of the query
  2. If you have index on an object which has been type casted using DB function like a date objects format has been changed using functions like To_char, then in that case the index used on this date object will not work.

Hope this has helped you to some extent, it will be more nice if you speak with your DBA.

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

#4

Thanks Steve and Omkar.

Rajun (BOB member since 2007-12-08)

#5

Take a look at the Reporter FAQ entry here, it still holds true for XI R2.

In addition you might consider the universe paramter JOIN_BY_SQL (do a search here on BOB, or ask your universe designer for more details on this).

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