Skip to Content

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.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

      1. Alexey Zimin
        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
        and
        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?

        Regards
        Alexey

        (0) 
  1. Pierre Leroux
    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?
    Thanks,
    Pierre Leroux

    (0) 
    1. Thomas Zurek 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.
      Thomas

      (0) 

Leave a Reply