Skip to Content
avatar image
Former Member

Does WEBi 4.2 support parallel BEx Query Execution

Hi All,

Can someone who has WEBi 4.3 (>=SP3 ) confirm if it supports parallel Query execution based on BEx Queries (Not universe). I checked many of the sap blogs/links, but its not clear. We are currently on BI 4.1 SP3 & planning to upgrade to 4.2 SP3.

Also, if it supports parallel queries based on BEx, is it ok if the underlying BW is 7.3 or should that be upgraded as well?

Thanks,

Pavan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 12 at 10:36 AM
    -1

    Hi,

    • It is not possible to run parallel queries on data providers based on “Direct Access to BEx queries” (BICS).

    For more details...please see below blog.

    https://blogs.sap.com/2016/01/22/new-webi-feature-in-bi42-parallel-queries/

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01, 2017 at 04:31 PM

    For BW parallel query run is enabled from BI 4.2 SP03.

    Section-Parallel Queries

    See attached link.

    https://archive.sap.com/documents/docs/DOC-74364

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2017 at 04:44 PM

    Hi Amit,

    I had seen this blog. But it says, "In SAP BI 4.2 SP3, parallel queries are supported for SAP BW data providers". Im assuming they are talking about connecting directly to BW backend data providers but there is no mention of BEx Queries as such. Am i missing something?

    Thanks,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Amit,

      As per this statement , "Parallel queries settings can be fine-tuned in CMC, information design tool and universe design tool, rather than through configuration files"

      I have IDT/UDT tools installed on both BO and Client_citrix Server .

      In BO server , by default parallel query parameter was enabled in configuration files .

      My query is , though parallel query parameter was enabled in configuration files , still do we need to set parallel query parameter on IDT/UDT tools in both BO and Client Server ?

      Please give your inputs here.