Web reporting performance

1. Try to make aggregates which fit the query most. That'll save some time getting the data.

2. Try to extend the time-out parameter (I don't know how it is called but a BC consultant could figure this out).

3. There are some nice presentations on performance on this service.sap.com. It can help you.

Hello:

Since you stated explicitly "when viewing reports over the web", I assume that your performance issue has been isolated to some extent (web queries instead of general query problems). Therefore things like aggregates and the timeout parameter are not likely your main bottleneck (you would notice the issue for all queries).

I would start here - on SDN, Business Information Warehouse > Performance Tuning section. The whitepaper on the performance tuning topic is available there, which is quite comprehensive.

Since the issue appears to be web-related, I would speculate that there may be an IGS issue. When analyzing the performance data, make sure that the front-end times for the queries you have problems with are high. Network overhead is a component to this - since BWQ results are compressed this shouldn't be a big overhead though.

In terms of optimizing/improving web performance, your killer apps are precalaculate template / information broadcasting. These techniques allow you to run the query ahead of time in the background and store the result set to deliver immediately when the user runs a query.

Good luck with the performance analysis. If you hit a wall you may consider contacting SAP Active Global Support or SAP Consulting for further assistance.

Regards -

Ron Silberstein, SAP