SAP BW: Administration and Performance Optimization, SAP Business Warehouse - Hardcover

Joe Darlak; Jesper Christensen

Hardcover

ISBN 10: 1592298532 ISBN 13: 9781592298532

Publisher: SAP Press, 2014

Synopsis

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

About this title

About the Author

Joe Darlak, director at COMERIT, Inc., has been successfully implementing SAP BW at clients since 1998, including several large-scale, full lifecycle global rollouts. He has significant experience increasing the capacity, reliability, and performance of SAP BI systems, defining and implementing processes and controls to stabilize service and mitigate risk, and improving the competency and skill sets of implementation and client service teams. Recently, he has architected one of the largest SAP BW migrations to SAP HANA on record, and has been instrumental in defining best practices for SAP HANA at Fortune 100 clients. Over the past decade, he has presented at multiple conferences on various SAP BW performance tuning topics. He is a former principal consultant in the iAnalytics practice at PricewaterhouseCoopers and holds a masters of business administration from the McCombs School of Business at the University of Texas at Austin.

Jesper Christensen, director of Business Intelligence International at COMERIT, Inc., was part of the SAP BW Regional Implementation group at SAP that initially rolled out SAP Business Warehouse. He is an internationally recognized subject matter expert in business intelligence, a contributing author of international BI journals, and a frequent speaker at SAP and BI-related conferences. His leadership at COMERIT helped Tetra Pak win the Gartner Award of BI Excellence in 2009. Jesper has supported multi-year global projects as the lead architect with companies such as ExxonMobil, Chevron, Statoil, Ericsson, Tetra Pak, Shell, BHP Billiton, and McKesson, among others.

Edition details

• Publisher: SAP Press
• Publication date: 2014
• ISBN 10: 1592298532
• ISBN 13: 9781592298532
• Binding: Hardcover
• Language: English
• Edition number: 1
• Number of pages: 652