BusinessObjects Board

Report performance tuning and Universe optimization

Hi guys,

Can someone please provide some tips or some learning documents on Report performance tuning and universe optimization.


Achilies :india: (BOB member since 2008-12-04)

In short, give away the work of db to itself. ‘Push down strategy’!

If you could accomplish a task in universe which you right now do it in your report, choose the way of doing it in universe itself.

Delete all the unused variables and formulas in the report.

Restrict the data at the data provider itself, instead of bringing it and filtering at the report level using filters.

Check this topic.

Most importantly check this FAQ.


Jansi :india: (BOB member since 2008-05-12)

Thank you Jansi,

That really helps :slight_smile:


Achilies :india: (BOB member since 2008-12-04)

Check also some of the presentations here:
http://www.integrasolutions.net/library_presentations.htm#design


Marek Chladny :slovakia: (BOB member since 2003-11-27)

This link looks great and information is really valuable.

Thanks!!


pranpad (BOB member since 2008-01-24)