SAP BW Performance Optimization Guide
Buch in deiner Nähe kaufen
Beschreibung
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
Provides basics as well as practical guidance for analysis and tuning of SAP BW 3.5
Contains in-depth description of BW data model, sizing, system load analysis, and DB indices
Shares insider knowledge on reporting performance, aggregates, compression, partitioning, and ETL performance
Autor*in
Thomas Schröder
Thomas Schröder works as a Managing Consultant in the department of Finance Transformation and Application Consulting at Capgemini Germany. He is a renowned specialist with many years of experience in the design and implementation of Business Intelligence solutions. He focuses on Business Intelligence strategy, Business Analysis, Data Modelling, Data Warehouse Architecture, and SAP Business Information Warehouse.
Themen in »SAP BW Performance Optimization Guide«
Business Information SAP Administration Data Warehouse SAP BI SAP NetWeaver