Webi report takes ever to run

[system]

Are you running the complete SQL of the Report or just a derived table of the universe which is part of SQL tables ???

There are many reasons to work on.

120×120 10.4 KB

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 :…

---

RUC (BOB member since 2010-05-03)