Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 09 at 02:16 PM

    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.
    Add comment
    10|10000 characters needed characters exceeded