Opening Edit Query Takes Too Much Time

[Former Member]

Hello everyone,

I try  to open edit quey view for one report however it takes too much time. For a while, I stop opening process.In the report, there are 22 queries and I guess this the real problem. So I woulşd ask to is there any way to export or open these queries easily? Also I try to open queries after purging the data but it doesn't work too.

Thank you for now.

[Former Member]

even without running the report , you have already impact the performance with your 22 queries ...add to this if you have many variable, filters, input control all that will charge your report and have a negative effect on BI performance

You must optimize your report , reduce  the number of queries , make the majority of the variable, filters on the front-end on universe level , re-size the platform ,CPU& memory..

Try to test the performance on DHTML mode

You can aslo make an update of your DB , indexing tables , archiveing DATA . this can have a + effect on you running time

[CarlyThomas]

Hi Nagihan,

What version of WebI are you using?  What is your data source?  Is based on a UNV or UNX?

22 queries is quite a lot and is likely the cause.  If you're in XI 3, the memory limits may be causing a delay if you're attempting to Edit Query via Infoview and therefore Sateesh's recommendation of using WebI Rich Client may help - but it is also 32 bit and may take awhile (or potentially crash) but the workload would be on the client machine rather than on the server.

Thanks,
Carly

[sateesh_kumar1]

Hi Nagihan,

Try with Rich Client .If you need only objects that are from query and filters , you can use =QuerySummary() function.