This is a kind of sequel to the Better Performance For Universe-Based Access To BW I've posted earlier this year. A long-term SAP customer provided real-world example that shows the performance improvements that have been achieved through the joint efforts of the WebI, ODA and BW development teams.
The scenario features 5 queries (drill steps) on a multiprovider scenario. Figure 1 compares the query run times of two setups:
- BW 7.01 (EhP1) SP4 with BOE 3.1 FP 1.4, and
- BW 7.01 (EhP1) SP5 with BOE 3.1 FP 1.8
The respective bars show the run time of 2. relative / in comparison to 1. For example: the run time of query 3 in scenario 2. is only 32% of the run time (of query 3) in scenario 1. In other words: query 3 took 68% less time meaning it ran about 3 times faster than before. Across the five queries run times decreased by 60%. Overall this should constitute an excellent incentive for customers to upgrade their respective installations.
* See Better Performance For Universe-Based Access To BW and Faster Universe-Based Access To BW via MDX.
Fig. 1: Comparing query run times before and after.