SAP BW: Administration and Performance Optimization, SAP Business Warehouse

Maintaining a high-performing SAP BW system is one part precise administration and one part ongoing tuning and this book, up to date for SAP BW 7.40, is your guide to both. Throughout the implementation process, from landscape architecture to initial system setup and from data modeling to efficient ETL, your to-do list dominates your desk. Master system setup, architecture, and configuration to lay a foundation for effective data storage, and then optimize your system through regular administration tasks. Consult best practices for creating SAP BW objects, running reports, and using jobs and skills profiles to make your system a well-oiled machine.

*Architect an SAP BW 7.40 system for optimal performance
*Explore step-by-step instructions for administration tasks performed daily, weekly, monthly, quarterly, and yearly
*Employ best practices for optimizing query and report performance and designing performance-driven data models

Performance Optimization
Design highly efficient data models leveraging the new features in SAP BW 7.40.

Tasks by Time Frame
Learn which administration tasks to perform daily, weekly, monthly, quarterly, and yearly.

System Setup and Architecture
Begin with system landscape design, system connections, change management, and system parameters. Implement a layered scalable architecture and adopt effective data loading and management techniques.

*System design and installation
*Data loading and management
*Data modeling performance tuning
*Roles and authorizations
*System checks
*Log and trace cleanup
*Hardware maintenance
*Database maintenance
*System refreshes
*Upgrades
*Reporting performance tuning