SAP BW: Administration and Performance Optimization
1st Edition
Published on 26. September 2014
Book
Hardback
652 pages
978-1-59229-853-2 (ISBN)
Description
As an administrator, your ongoing to-do list dominates your desk. Let us help: With this book, learn the daily, monthly, quarterly, and yearly administration tasks you should be performing, and how to perform them. This comprehensive guide will walk you through system setup and configuration to lay a sound foundation for effective data storage, and then teach you to employ performance tuning techniques to optimize system performance. Consult detailed best practices to learn how to create BW objects and run reports, as well as to effectively use jobs and skills profiles for system support. Advance your SAP BW system from a B-movie to a blockbuster.
Highlights:
System design and installation
System and data architecture
Data loading and management
Hardware maintenance
Alerting
Reporting performance tuning
Database maintenance
Data modeling performance tuning
Log and trace cleanup
System checks
Housekeeping tasks
More details
Persons
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.
Content
Foreword ... 13
Preface ... 15
PART I Initial System Setup
1. Configuring Your System Environment ... 21
1.1 Infrastructure Architecture ... 22
1.2 System Landscape ...42
1.3 System Sizing ... 78
1.4 System Settings ... 98
2. Data Architecture and Loading ... 109
2.1 Data Flow in SAP BW ... 110
2.2 Layer Architectures of a Data Warehouse ... 117
2.3 Graphical Modeling ... 125
2.4 Data Load Automation ... 134
3. Data Management ... 157
3.1 Master Data ... 158
3.2 Transaction Data ... 184
3.3 Temporary Data ... 196
3.4 Data Retention Strategy ... 205
3.5 Near-Line Storage ... 212
4. Roles and Authorizations ... 217
4.1 Authorization Concept in AS ABAP ... 217
4.2 Standard Authorization Objects ... 221
4.3 Analysis Authorizations ... 225
4.4 Roles ... 231
4.5 User Administration ... 236
4.6 Troubleshooting Authorization Problems ... 242
PART II Performance Tuning
5. Data Modeling and Loading for Performance ... 253
5.1 Data Modeling for Performance ... 253
5.2 Data Loading for Performance ... 317
6. Reporting Performance Tuning ... 357
6.1 Identifying Performance Problems ... 357
6.2 Reporting Performance Tuning ... 405
PART III Administration Tasks in Your SAP BW System
7. Daily Tasks ... 425
7.1 Daily Administration Tasks ... 425
7.2 Daily Data Load Monitoring Tasks ... 446
8. Weekly Tasks ... 455
8.1 Weekly Administration Tasks ... 455
8.2 Weekly Performance Tuning ... 473
9. Monthly Tasks ... 481
9.1 Monthly Administration Tasks ... 482
9.2 Monthly Performance Tuning ... 499
10. Quarterly Tasks ... 509
10.1 Quarterly Administration Tasks ... 509
10.2 Quarterly Performance Tuning Tasks ... 530
11. Yearly Tasks ... 547
11.1 Yearly Administration Tasks ... 548
11.2 Yearly Performance Tuning Tasks ... 564
PART IV Support for Your SAP BW System
12. BI Competency Center ... 575
12.1 Centralized Support Organization ... 577
12.2 Roles and Skill Sets ... 585
12.3 Team Structure ... 596
12.4 Best Practices ... 599
Appendices ... 605
A. Checklists ... 607
A.1 Development Checklists ... 607
A.2 Housekeeping Checklists ... 614
B. Transaction Codes ... 619
C. Reports and Utilities ... 629
D. The Authors ... 637
Index ... 639