SAP BW Performance Optimization Guide

Features

• Cover Type: Hard Cover with 450 pages
• Published by: SAP Press
• Edition: 1st Edition August 2006
• Written in: English
• ISBN 10 Number: 1592290809
• ISBN 13 Number: 978-1592290802
• Book Dimensions: 9.6 x 7 x 1.1 inches
• Weighs: 1.9 pounds

Book Description
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 Include:

- 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

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.

Reader Reviews
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.