Hi,
We are using BO 6.5 and we have developed some reports in these reports we have used lot of complex forumlas and variables used. So could you please give suggestion for this I want increase report performance and reduced formula’s and variables. So please any body some suggestion on this.
Can I go database level or Universe level.
Regards,
Kala
kalabo 
(BOB member since 2008-05-14)
If you are using a formula across reports ,try creating the formulas in the universe itself
Rajasekar 
(BOB member since 2004-07-16)
‘Push down’ strategy will also help improving the performance. Leave the database to do its work itself, instead of trying to do it at the report level.
Jansi (BOB member since 2008-05-12)
The further back you do the work, the more reusable it is.
If you get the ETL process to do the work, then do so.
If not, then get the universe changed.
Only then look at lumping processing into reports.
Consider what you want to achieve and how you would achieve it at a database level.
Could aggregate tables support what you are doing?
Would a new fact table at a similar level of grain to current fact tables help?
Unfortunately we don’t know your data.
Heavy lifting work like complex calculation and business rules should always be performed on the database level. This will optimize the performance.
substring 
(BOB member since 2004-01-16)