Skip to Content
0
Former Member
May 01, 2014 at 05:39 PM

Performance Issues with Webi Reports

18 Views

Hi,

my BI architecture:

- SAP BW 7.01 SP7

- BO XI3.1 SP 1.12

Data model:

- 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 Order

Purchase 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.

Questions are:

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?

Regards

Giuseppe