Skip to Content
avatar image
Former Member

Opening Edit Query Takes Too Much Time


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 02, 2015 at 09:35 AM

    Hi Nagihan,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 06:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2015 at 03:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded