my BI architecture:
- SAP BW 7.01 SP7
- BO XI3.1 SP 1.12
- 2 DSO (1 for Purchase Request with about 600.000 record and 1 for Purchase Order with 1.000.000 record)
- 1 MultiProvider with the 2 DSO above
- 1 BEx query over MP
- BO Universe built on BEx query
Example of Record in DSO:
DSO Purchase Request:Purchase Request PR value 1 1.000 2 3.000 3 5.000 ... ...
DSO Purchase OrderPurchase Order Purchase Request Issue date PO value A 1 10/10/2013 100 B 1 10/10/2013 200 C 2 10/11/2013 300 D 2 10/13/2013 400 E 3 10/14/2013 500 ... ... ... ...
I need a report (WEBI) to show (filter on Issue date 10/10/2013)Purchase Order Purchase Request PR value PO value A 1 1.000 100 B 1 1.000 200
so in WEBI I built a new report with 2 query:
query 1) Dimension: Purchase Order / Purchase Request / PO value - Filter: Issue date
query 2) Dimension: Purchase Request / PR value
Also, in Report I merged dimension "Purchase Request" to have result showed above.
This Report go in time out for memory problem.
How many record are processed in WEBI report?
From DSO PO (query 1) I think only 2 record (applied filter on issue date 10/10/2013), but I have doubts on record processed by query 2: 1 record (applied filter from result of first query...) or all record of DSO purchase request (more than 600.000 record) causing performance issue...
Do you have some suggestion?
I read note no.1946036 (MDX: Long runtime and high memory consumption with filter function) regarding an optimization missing and an excessive volume of data is requested from the OLAP processor. Solution suggested: Import Support Package 15 in SAP BW.
Do you think I solve performance issue with last SP?