Blogs
|
Performance Study: Web Intelligence on top of SAP BW
 
|
|
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:
- 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.
Thomas Zurek
Thomas is VP for R&D of SAP BW and analytic parts of HANA. You can follow @tfxz
| Showing messages 1 through 7 of 7. | ||
|
|
||
| Titles Only | Main Topics | Oldest First |
- Performance
2010-10-27 11:03:19 Pierre Leroux
Business Card
[Reply]
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
- Performance
2010-10-28 03:01:37 Thomas Zurek
Business Card
[Reply]
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
- 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
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- Improvemets for BO Edge
2010-03-15 08:00:59 Efstratios Karaivazoglou
Business Card
[Reply]
FP 1.1 for BO Edge = FP 1.5 for BO Enterprise
FP 1.2 for BO Edge = FP 1.8 for BO Enterprise- Improvemets for BO Edge
2010-03-15 08:24:58 Alexey Zimin Business Card [Reply]
Dear Efstratios, thanks a lot for the answer!
| Showing messages 1 through 7 of 7. |