SAP BW/4HANA
An Introduction
1st Edition
Published on 25. August 2017
Book
Hardback
427 pages
978-1-4932-1531-7 (ISBN)
Description
What is SAP BW/4HANA? More importantly, what can it do for you? Between these pages, you'll explore the answers to these questions, from simplified data models and SAP BW/4HANA Analytics to automated data lifecycle management. You'll find step-by-step instructions for installation and setup, a guide to administrative tasks to keep your SAP BW/4HANA system in tip-top shape, and the low-down on security in your new system. Explore the data warehouse of the future!Highlights include:-SAP HANA-SAP BW/4HANA Analytics-Installation and deployment-Data modeling-Reporting and analytics-Data lifecycle management-Administration-Security-Data warehousing solution
Highlights:
-SAP HANA
-SAP BW/4HANA Analytics
-Installation and deployment
-Data modeling
-Reporting and analytics
-Data lifecycle management
-Administration
-Security
-Data warehousing solution
More details
Persons
Author
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.
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.
Marcos Poles is a senior SAP solution architect, SAP certified consultant, and author of articles published in international BI journals. Marcos started his SAP career in 1996, SAP Academy instructor in 1998, and subsequently dedicated to manage and deliver SAP HANA, SAP BW, and BI integrated solutions for large corporations in Americas and Europe covering major business processes of Financials & Controlling, Supply Chain, and Sales & Marketing including Customer Activity Repository (SAP CAR), Demand Signal Management (SAP DSiM), and Demand Planning (SAP APO).
Marcos Poles achieved management positions in Accenture and Deloitte and his education background includes Bachelor in Physics and Master Business Administration in Information Technology both from University of Sao Paulo, Brazil.
Content
... Preface ... 15
... Who This Book Is For ... 15
... How This Book Is Organized ... 15
... Acknowledgments ... 16
... Conclusion ... 17
1 ... Introduction to SAP BW/4HANA ... 19
1.1 ... History of SAP BW ... 19
1.2 ... SAP BW/4HANA Overview ... 25
1.3 ... Implementing SAP BW/4HANA ... 32
1.4 ... Summary ... 37
2 ... Introduction to SAP HANA ... 39
2.1 ... What Is SAP HANA? ... 39
2.2 ... SAP HANA as an Application Platform ... 43
2.3 ... SAP HANA as a Database for SAP Applications ... 44
2.4 ... SAP HANA Deployment ... 49
2.5 ... Virtualization ... 55
2.6 ... Summary ... 58
3 ... Installation and Setup ... 59
3.1 ... Preparation ... 59
3.2 ... Installation ... 62
3.3 ... Postinstallation ... 70
3.4 ... Summary ... 76
4 ... SAP BW/4HANA in the Cloud ... 77
4.1 ... Choosing a Cloud Provider ... 77
4.2 ... Cloud Providers ... 81
4.3 ... SAP BW/4HANA Cloud Deployment Steps ... 87
4.4 ... Summary ... 99
5 ... Data Modeling ... 101
5.1 ... Modeling Perspectives ... 101
5.2 ... Modeling Objects ... 104
5.3 ... InfoObjects ... 106
5.4 ... SAP BW/4HANA InfoProviders ... 117
5.5 ... Summary ... 139
6 ... Data Acquisition ... 141
6.1 ... SAP BW/4HANA Source Systems ... 142
6.2 ... SAP BW/4HANA DataSources ... 154
6.3 ... SAP BW/4HANA Data Flows ... 168
6.4 ... SAP BW/4HANA Data Loading ... 178
6.5 ... Manual Data Acquisition ... 185
6.6 ... Summary ... 187
7 ... Reporting and Analytics ... 189
7.1 ... SAP BW/4HANA Queries ... 190
7.2 ... Interfaces for Analysis ... 228
7.3 ... SAP BusinessObjects Tools ... 232
7.4 ... Third-Party Business Intelligence Tools ... 239
7.5 ... Summary ... 248
8 ... Integrating External Data ... 251
8.1 ... SAP HANA Smart Data Access ... 251
8.2 ... SAP HANA Smart Data Integration ... 260
8.3 ... Integration with SAP BW/4HANA ... 279
8.4 ... Summary ... 287
9 ... Data Lifecycle Management ... 289
9.1 ... Data Retention Strategy ... 290
9.2 ... Data Temperature ... 296
9.3 ... Data Archiving ... 305
9.4 ... Summary ... 330
10 ... Administration ... 331
10.1 ... Daily Administration Tasks ... 331
10.2 ... Daily Load Monitoring ... 356
10.3 ... Weekly, Monthly, Quarterly, and Annual Tasks ... 359
10.4 ... Summary ... 361
11 ... Security ... 363
11.1 ... Authentication and Single Sign-On ... 363
11.2 ... Authorization in Application Server for ABAP ... 365
11.3 ... Standard Authorization Objects ... 369
11.4 ... Analysis Authorizations ... 376
11.5 ... Roles ... 380
11.6 ... User Administration ... 385
11.7 ... Troubleshooting Authorization Problems ... 390
11.8 ... Summary ... 396
12 ... The Future of SAP BW/4HANA ... 397
12.1 ... SAP BW to SAP BW/4HANA Roadmap ... 397
12.2 ... Openness ... 399
12.3 ... Simplicity ... 402
12.4 ... User Interfaces ... 407
12.5 ... High Performance ... 411
12.6 ... Future Innovations ... 412
12.7 ... Future Migration Options ... 413
12.8 ... Summary ... 414
... Appendices ... 415
... The Authors ... 415
... Index ... 419
... Who This Book Is For ... 15
... How This Book Is Organized ... 15
... Acknowledgments ... 16
... Conclusion ... 17
1 ... Introduction to SAP BW/4HANA ... 19
1.1 ... History of SAP BW ... 19
1.2 ... SAP BW/4HANA Overview ... 25
1.3 ... Implementing SAP BW/4HANA ... 32
1.4 ... Summary ... 37
2 ... Introduction to SAP HANA ... 39
2.1 ... What Is SAP HANA? ... 39
2.2 ... SAP HANA as an Application Platform ... 43
2.3 ... SAP HANA as a Database for SAP Applications ... 44
2.4 ... SAP HANA Deployment ... 49
2.5 ... Virtualization ... 55
2.6 ... Summary ... 58
3 ... Installation and Setup ... 59
3.1 ... Preparation ... 59
3.2 ... Installation ... 62
3.3 ... Postinstallation ... 70
3.4 ... Summary ... 76
4 ... SAP BW/4HANA in the Cloud ... 77
4.1 ... Choosing a Cloud Provider ... 77
4.2 ... Cloud Providers ... 81
4.3 ... SAP BW/4HANA Cloud Deployment Steps ... 87
4.4 ... Summary ... 99
5 ... Data Modeling ... 101
5.1 ... Modeling Perspectives ... 101
5.2 ... Modeling Objects ... 104
5.3 ... InfoObjects ... 106
5.4 ... SAP BW/4HANA InfoProviders ... 117
5.5 ... Summary ... 139
6 ... Data Acquisition ... 141
6.1 ... SAP BW/4HANA Source Systems ... 142
6.2 ... SAP BW/4HANA DataSources ... 154
6.3 ... SAP BW/4HANA Data Flows ... 168
6.4 ... SAP BW/4HANA Data Loading ... 178
6.5 ... Manual Data Acquisition ... 185
6.6 ... Summary ... 187
7 ... Reporting and Analytics ... 189
7.1 ... SAP BW/4HANA Queries ... 190
7.2 ... Interfaces for Analysis ... 228
7.3 ... SAP BusinessObjects Tools ... 232
7.4 ... Third-Party Business Intelligence Tools ... 239
7.5 ... Summary ... 248
8 ... Integrating External Data ... 251
8.1 ... SAP HANA Smart Data Access ... 251
8.2 ... SAP HANA Smart Data Integration ... 260
8.3 ... Integration with SAP BW/4HANA ... 279
8.4 ... Summary ... 287
9 ... Data Lifecycle Management ... 289
9.1 ... Data Retention Strategy ... 290
9.2 ... Data Temperature ... 296
9.3 ... Data Archiving ... 305
9.4 ... Summary ... 330
10 ... Administration ... 331
10.1 ... Daily Administration Tasks ... 331
10.2 ... Daily Load Monitoring ... 356
10.3 ... Weekly, Monthly, Quarterly, and Annual Tasks ... 359
10.4 ... Summary ... 361
11 ... Security ... 363
11.1 ... Authentication and Single Sign-On ... 363
11.2 ... Authorization in Application Server for ABAP ... 365
11.3 ... Standard Authorization Objects ... 369
11.4 ... Analysis Authorizations ... 376
11.5 ... Roles ... 380
11.6 ... User Administration ... 385
11.7 ... Troubleshooting Authorization Problems ... 390
11.8 ... Summary ... 396
12 ... The Future of SAP BW/4HANA ... 397
12.1 ... SAP BW to SAP BW/4HANA Roadmap ... 397
12.2 ... Openness ... 399
12.3 ... Simplicity ... 402
12.4 ... User Interfaces ... 407
12.5 ... High Performance ... 411
12.6 ... Future Innovations ... 412
12.7 ... Future Migration Options ... 413
12.8 ... Summary ... 414
... Appendices ... 415
... The Authors ... 415
... Index ... 419