Skip to Content
Author's profile photo Thomas Zurek

Performance Study: Web Intelligence on top of SAP BW

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:

  1. BW 7.01 (EhP1) SP4 with BOE 3.1 FP 1.4, and
  2. 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.

Query Performance
Fig. 1: Comparing query run times before and after.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Dear Thomas,

      can you clarify will this improvements work in BO EDGE 3.1 FP 1.1 (latest for now)?

      Best regards

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort

      the FixPacks mentioned for BusinessObjects Enterprise are the same for BusinessObjects Edge.


      Author's profile photo Former Member
      Former Member
      Hi Ingo,

      what does it mean the same? At present I see following FixPacks in SAP SWDC:
      BOBJ Edge BI 3.1 Fix Pack 1.1 for Server Components dated 23.10.2009
      BOE XI 3.1 FixPack 1.9 (Server + Client)  dated 06.11.2009
      What is the correlation of this fixpacks? Does FP 1.1 for Edge includes the same improvements  as FP 1.8 for BOE or we should wait for FP 1.8 for BOBJ Edge?


      Author's profile photo Efstratios Karaivazoglou
      Efstratios Karaivazoglou
      FP 1.1 for BO Edge = FP 1.5 for BO Enterprise
      FP 1.2 for BO Edge = FP 1.8 for BO Enterprise
      Author's profile photo Former Member
      Former Member
      Dear Efstratios, thanks a lot for the answer!
      Author's profile photo Former Member
      Former Member
      Dear Thomas,
      Could you clarify what these graphics are measuring?
      Is 100% the baseline for old performnance (vs 70% now for query 1, etc).

      If I interpreted these results properly, it shows that we have improved the performance. If possible can you comment on the improvement in general (if we run a multitude of scenarios, on average, what the performance improvement?
      Pierre Leroux

      Author's profile photo Thomas Zurek
      Thomas Zurek
      Blog Post Author
      Hi Pierre,
      yes, the "100% base line" for each query is the performance seen with BW 7.01 (EhP1) SP4 and BOE 3.1 FP 1.4.
      It is difficult to make performance statements in a general context - like version A is X times faster than version B. As can be seen in the example above, there is query 1 is about 1.3 times faster while query 4 is 3 times faster (as it benefits more of the changes). So what would be a fair summary 1.3 or 3?
      That's why this little benchmark provided by a customer and showing arbitrary real-world queries is a nice example which gives you a flavour of what's in those SPs and FPs.

      I hope this helps.