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