Blogs

Thomas Zurek

Performance Study: Web Intelligence on top of SAP BW
Thomas Zurek SAP Employee
Business Card
Company: SAP AG
Posted on Nov. 11, 2009 06:56 AM in BI Accelerator, Business Intelligence (BI), Business Objects, Web Intelligence

Subscribe.Subscribe
Print. Print
Permalink Permalink

This is a kind of sequel to the blogs* 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.

Thomas Zurek Thomas is VP for R&D of SAP BW.


Add to: del.icio.us | Digg | Reddit

Comment on this article
Comment on this weblog
Showing messages 1 through 3 of 3.
Titles Only Main Topics Oldest First

  • Improvemets for BO Edge
    2009-11-11 08:34:02 Alexey Zimin Business Card [Reply]

    Dear Thomas,


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


    Best regards
    Alexey

    • Improvemets for BO Edge
      2009-11-11 12:53:29 Ingo Hilgefort SAP Employee Business Card [Reply]

      Hi,


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


      regards
      Ingo

      • Improvemets for BO Edge
        2009-11-12 10:29:23 Alexey Zimin Business Card [Reply]

        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

Showing messages 1 through 3 of 3.