Tips and Techniques for Optimal Query Performance with SAP NetWeaver BI Accelerator

  • by Catherine Roze, Senior BW Consultant
  • January 1, 2009
SAP NetWeaver BI Accelerator, available with SAP NetWeaver BI 7.0 and later, can reduce reliance on aggregates and improves how the system reads data, resulting in faster query performance. Find out which scenarios work best with the accelerator and learn which tasks you should carry out for the best possible accelerator performance.
Key Concept
The SAP NetWeaver BI Accelerator helps improve SAP NetWeaver BI query performance with little to no query tuning, aggregate building, or impact on users. The accelerator generally produces a query runtime speed-up factor of between 10 and 100 times. Although the accelerator can be delivered only in hardware and software configurations certified by SAP, there are no dependencies with hardware, database vendors, or the SAP NetWeaver BI operating system to which the accelerator is connected.

As InfoCube volume grows or when dimension complexities increase (e.g., navigation attributes, time dimensions, or multiple hierarchies), the data access performance of BI queries starts to degrade rapidly. Performance challenges can prevent companies from meeting service levels related to query performance. In such situations, you can consider using SAP NetWeaver BI Accelerator (the accelerator). Better performance and more stable response times lead to increased user productivity. Furthermore, you reduce the total cost of operations (TCO) by avoiding aggregate maintenance, consolidating currently overloaded SAP NetWeaver BI systems, and simplifying data modeling, for example.

What follows is a series of tips and techniques to optimize SAP NetWeaver BI query performance with the accelerator. We will provide advice for planning, implementing, and maintaining SAP NetWeaver BI Accelerator and for troubleshooting performance issues. We offer lessons learned and undocumented tips to optimize accelerator performance, including how to avoid overload. We will also cover some of the unexpected accelerator issues that you may not find until testing or after the accelerator is live in your productive system.

Catherine Roze

Catherine Roze is a senior BI consultant with more than seven years of full life cycle experience in SAP reporting and SAP NetWeaver BW with special focus on SAP NetWeaver BW enterprise reporting, performance optimization, and SAP NetWeaver BW Accelerator. A seasoned BI professional, she has contributed to more than 15 SAP NetWeaver BW implementation projects for Fortune 500 companies. Catherine holds an MBA and MS (industrial technology) and is the author of SAP BW Certification: A Business Information Warehouse Study Guide.

See more by this author


Comments

6/20/2013 12:03:48 PM
Scott Wallask, Managing Editor

Hi Jay -- I agree with you, that's a nice idea. I've been in touch with our author recently about other topics, so I will ask if she could indeed update this article (or find someone else who will). Thanks for writing.
6/20/2013 11:42:51 AM
Jay

Would be great to update this article to reflect the BW 7.30 & BWA 720 functionality.

Please log in to post a comment.

To learn more about subscription access to premium content, click here.