Skip to Content
author's profile photo Former Member
Former Member

Parallel processing of BEx queries under Webi report

Environment - BO 4.0 SP5

We have Webi reports built on top of BEx queries (maximum 3 queries). Each of them taking more time in webi side however, in BW side queries run considerably fast. But, when the webi call happens each of them go for a serial execution.

Can we make them to run in parallel so that the performance will be improved? is there any settings available to do that.

Thanks,

Tilak

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 03, 2013 at 12:38 AM

    Hello Tilak,

    Web Intelligence does not support the parllel execution of BEx queries.

    regards

    Ingo Hilgefort, SAP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2013 at 11:12 AM

    Hello Tilak,

    I guess there are a couple of enhancement request on this as this is a product limitation that queries are executed serially. Please take a look at the following KBA:

    "1330124 - Unable to run multiple queries in parallel in Web Intelligence or Desktop Intelligence"

    https://service.sap.com/sap/support/notes/13330124

    Thanks,

    Madhumitha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2013 at 06:46 PM

    Tilak,

    My understanding is that BI 4.0 SP6 is the latest release that introduced parallel query processing. Apparently, the parallel processing feature can also be controlled on the back end. If you check the properties of the query in RSRT, make sure the option "No Parallel Processing" has been unchecked.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2013 at 09:42 AM

    rsrt is in sap bi to execute the report. and parllel process is not there in webi i think so...

    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.