Webi report takes ever to run

[system]

Hi,
One of my webi report takes ever to run. Other reports are working fine, its just that report. I have tested in toad by running the sql from the derived table and the data is returned in a short span of time.There are other reports which are built on derived table as well but they seem to run ok.
Any Idea what is going on or how should I debug?

Thanks for your reply in advance. Experts plz help.

---

AFAF (BOB member since 2012-07-13)

[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.

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

---

RUC (BOB member since 2010-05-03)

[system]

Thanks RUC for your reply suggested link had provided usefull Steps for solutions.

So, One more thing for my knowledge.Why does query takes longer to run in Infoview than in Rich client? I understand there is a middle layer (a web server) but the query in Rich client takes 2 mins whereas in Infoview it takes 3 min. Which means is takes 1 extra minute.

Thank you.

---

AFAF (BOB member since 2012-07-13)