SAP BW Performance Optimization Guide

Finally, a detailed reference that gives administrators expert instruction to analyze and optimize performance in SAP BW. All the BW basics are covered such as architecture and data modelling, plus the ins and outs of systematic performance analysis, as well as volumes of valuable data design tips.

Readers get an in-depth introduction to SAP BW indices, statistics, and database optimizers and learn about the key aspects of reporting performance. Full-length chapters deal with aggregates as well as extraction and loading performance. Plus, of course, the mission-critical topics of compression and InfoCube partitioning are discussed extensively. The depth and breadth of the information in this book, together with practical guidance that you can use right away, gives administrators the tools to analyze and tune BW performance immediately.

Highlights include:

• BW architecture, sizing, and data modeling
• 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