SAP BW Performance Optimization Guide [Hardcover]

Thomas Schroder (Author)

Book Description

Publication Date: August 1, 2006

This book provides comprehensive guidance to analyze and optimize performance in SAP BW Release 3.5. First, the author introduces you to basic SAP BW concepts (architecture, data modeling), key methods and tools for systematic performance analysis, as well as exclusive data design tips.

Then, benefit from expert insights on indices, statistics, database optimizers, and critical aspects of reporting performance. Full-length chapters deal with aggregates as well as extraction and loading performance. In addition, InfoCube partitioning and compression are discussed extensively.

This unique reference gives administrators the background knowledge, practical guidance, and all the tools needed to effectively analyze and tune BW performance immediately. Plus, BW developers benefit from detailed data design descriptions and expert tips that cannot be found elsewhere.

Highlights:

• BW architecture, sizing, and data modelling
• System load analysis
• Indices and database statistics
• Reporting performance: OLAP Cache, query monitor and trace, BW Reporting Agent, front-end performance and network, BEx queries and Excel workbooks
• Aggregates
• Compression and Partitioning
• Extraction and loading performance: Integration of data sources, data flow, communication and transfer techniques, Persistent Staging Area, Performance Aspects for load, data extraction, and data transformation processes
• Update of InfoCubes and ODS Objects

Editorial Reviews

About the Author

Thomas Schröder is a managing consultant in the Finance Transformation – Application Consulting area at Capgemini Deutschland GmbH, Germany. His consulting work focuses on business intelligence strategies, business analytics, data modeling, data warehousing architectures, and SAP BW.

Product Details

• Hardcover: 450 pages
• Publisher: SAP PRESS, 1st edition; 1 edition (August 1, 2006)
• Language: English
• ISBN-10: 1592290809
• ISBN-13: 978-1592290802
• Product Dimensions: 9.6 x 7 x 1.1 inches
• Shipping Weight: 1.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #620,097 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars SAP BW, January 12, 2008

By 

Satnam Nijjar - See all my reviews
(REAL NAME)   

This review is from: SAP BW Performance Optimization Guide (Hardcover)

This book was recommended to me by a co-worker and I would like to recommend to any one who is interested to get started or gain expert level knowledge in SAP BW. Excellent book on this subject.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Excellent Book - Very Useful for SAP Basis for BW Administration, December 27, 2007

By 

S. Mutyala "Suresh Reddy" (Atlanta, GA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: SAP BW Performance Optimization Guide (Hardcover)

Excellent Book - Very Useful for SAP Basis for BW Administration.

This book is a must for every SAP BW Basis Administrators.

Chapter 4 covers Memory management.
Chapter 8 covers a lot of BW specific load analysis.
Chapter 9 covers indexes and database statistics for BW.
Chapter 11, 12, and 13 are good for performance (aggregates, compression, loading, extraction, etc.)

Money is well spent on this book.

4.0 out of 5 stars Good book, December 11, 2008

By 

Anand Gupta "Anand Gupta" (London) - See all my reviews
(REAL NAME)   

This review is from: SAP BW Performance Optimization Guide (Hardcover)

Could be updated. As a matter of fact some of the performance statistics keep on evolving because of availability of better hardware. So the design decisions can change because of changes / improvements in hardware. Difficult to see how that can be addressed though!