Performance Issues with Webi Reports

[Former Member]

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

[sateesh_kumar1]

Hi Hiuseppe ,

We can have a single BEx query on your multiprovider.

No need to have 2 queries.

since you don't have date filter for query 2 in the report it is bringing all the data into report.

[Former Member]

Hi Sathish,

I have already only 1 BEx query on MP.

I have 2 query in WEBI Report (one way to show in the report PR value)

In second query (of WEBI) I cannot have "Issue date" as filter because "Issue date" is related only Purchase Order".

[sateesh_kumar1]

Since you did BEx on multi provider you can get all the data with 1 query itself.

apply date range variable in BEx and Run query and in RSRT to validate the data.Then proceed to webi development.

[Former Member]

Applying the filter in the BEx QUERY, are selected only records from DSO of Purchase Order and not the record from the DSO of Purchase Request, because the dimension on which you make the filter (Issue Date) is not present in DSO of Purchase Request (see DSO schema in my first post).

This is due for the logical data extraction from a MP (correct?).

From my experience, the only way to get all the data into a single report is to use functionality "Merge dimension" in WEBI Report or there are other way?