Hi all,
I want to Improve Universe performance for reporting Purpose. So any one can sugest me please.!!!
suhas.BOBI 
(BOB member since 2010-12-09)
For Universe performance or fine tuning depends on
- the size of underlying database
- Indexes used in DB tables.
Basic steps of Universe design to improve performance:
- Using aggregate_awareness to base queries on aggregate tables .
- Optimizing array fetch parameter in universe parameter.
- Modifying number of rows returned by a table
- Using short cut joins.
- Build objects/dimensions (for eg. Acct Nos, Cust No) from lookup tables rather than fact.
- Use sum() for all measure objects wherever necessary to limit rows returned into the micro cube in reports.
I have added few points, maybe others can add more to it.
dw.vishal (BOB member since 2005-11-08)
Hi,
This FAQ can help too:
Marek Chladny 
(BOB member since 2003-11-27)
Hi,
Great Â…Â…ItÂ’s really helpfully discussion for tuning the universeÂ…Â….Thank youvery much MarekÂ…!!!
suhas.BOBI (BOB member since 2010-12-09)
Doesn’t modifying the number of rows gives wrong results…I mean What is the purpose of decreasing the number of rows returned…Isn’t it a partial answer to a query
koundinya17 (BOB member since 2010-11-18)