I have developed a WAD dashboard report that has 10 chart items and some buttons. Data provider for all the charts are diff virews, created from the same query. Query has complex structures. My query is so complex but takes only 10 sec to run in the Bex analyzer. that same query is feeding to all the 10 views of my WAD dashboard rep and it is taking almost 60-70 secs in Production. I tried all the ways to improve performance but I couldn't find anything. Do we need to set anything in WAD or IE or firefox that will increase the speed of report?
I need to increase the speed in IE. I havent created iviews yet. Desperately finding the answer.
Appreciate your quick response on this.