Universe optimization

[system]

hi friends,
Can anybody help me ,how can I achive universe optimisation?
Or what steps shall I follow for universe to perform the best .

Also pls suggest me ,if I will apply weight for each table in universe,how it will help me for universe optimization?

Thanks in advance for your time and suggestions!!!

---

girijakt (BOB member since 2010-06-17)

[system]

Hi,

These 2 topics can help in general:

Webi & Better Performance

Below is from my notes. Couple Questions: what am I missing below? “…Allocating table weights…”: how do I do that, and what are the benefits? “.…Minimizing usage of derived tables….”: What are the benefits? I thought having derived tables has zero effect --apparently I’m wrong– for XIR2 web.xml location is fine, for XIR3 there are more than one web.xml files exist, for timeout purposes which one to modify? thanks MrH =========================================== :: :: Faster WEBI Reports :…

FAQ: Reporter

Why is my report so slow? Submitted by kmahler, additional comments by Andreas (July 2009). What makes up the total time a report runs from hitting the Refresh button to being displayed: Query execution time (database side) Transferring results across the network to the client/web browser (network bandwidth & latency) Computing local report variables, formulas, local report filters, alerters, etc. within the report (BOE server/ DesktopIntelligence workstation) Rendering the page (pag…

---

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