Skip to Content
0

BO Universe - Relational Connection – No Parallel Execution of Sub-Queries

May 09 at 06:50 AM

37

avatar image

Hello BO Experts,

I got a report requirement where I need to report data coming from 2 fact tables as comparison in a table in WebI.

I modelled the universe with those fact tables and surrounding shared dimension tables (DATE and some MASTERDATA) and usage of two contexts.

Query result (which fetches both facts together along with dim values) is accurate.

However, when looking at the data federator monitor (it is using a JCO connection to SAP ERP) I noticed that the contexts are executed sequentially.

Which baffled me as I would have expected Context 1 (to get fact 1) and Context 2 (to get fact 2) are executed at the same time and once both are completed the full outer join would be done to put the results together.

Do I miss a setting somewhere? Or is this expected behaviour? Or is there another way to get the parallel execution? Because with this behaviour the runtime of the report basically doubles.

We are on BI 4.2 SP3

Thanks and best regards,

Axel

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

1 Answer

Jawahar Konduru May 09 at 02:16 PM
0

Looks like parallel queries are not supported for BEx.

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

A summary of the limitations in SAP BI4.2 are as follows:

  • It is not possible to run parallel queries on data providers based on “Direct Access to BEx queries” (BICS).
  • It is not possible to run parallel queries on data providers based on “Analysis Views”.
  • It is not possible to run parallel queries on data providers based on Excel files.
  • It is not possible to change parallel query setting for each database connection. I believe that this will be looked at being incorporated into a support pack later than BI4.2 SP01.
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Well. This is a Connection via JCO to ERP. No BEx queries. I assume JCO is not using BICS....

0