Book Description

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