Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.