SAP BW Performance Optimization Guide

Title: SAP BW Performance Optimization Guide
Author: Thomas Schröder
ISBN: 1592290809 / 9781592290802
Format: Hard Cover
Pages: 450
Publisher: SAP Press
Year: 2006
Availability: Out of Stock

Tab Article

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.

Tab Article

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