Skip to Content
0
Former Member
Mar 18, 2009 at 05:59 AM

Performance Issue with Webi report uses SAP BI Query as the data source

30 Views

Hello.

I have created a Webi ad-hoc report which connects to a SAP BI query through BO OLAP universe.

The layout of Webi is the exactly the same as the BI query. There are filters in the Webi to restrict the number of data extraction, but even with data result of 5000 rows, it took about 30 seconds.

If I execute the BI query with the same filter restriction, it tooks less than 10 seconds.

It seems that large percentage of time is consumed at the MDX part.

Is there any tuning method that could speed up the process time of MDX?

Thank you.

Justine

Edited by: Justine Liu on Mar 18, 2009 6:59 AM