Skip to Content
0

Does WEBi 4.2 support parallel BEx Query Execution

Feb 01, 2017 at 04:10 PM

278

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member 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/

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 01, 2017 at 04:31 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 01, 2017 at 04:44 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

as you mentioned "connecting directly to BW back end data providers" means talking about BICS connectivity and BW providers can be multi provider or BEx query.

if you see the same section again "In CMC and information design tool: Max Parallel Queries per connection parameter for OLAP connections." These parameters for BICS(OLAP connection).

or check page 39 & 40 in the link.

Support Parallel Data Provider for SAP BW Direct Access

http://www.sap.com/documents/2016/08/eac32305-847c-0010-82c7-eda71af511fa.html#

1

That's correct Amit.

1

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.

0