Thorsten Lüdtke is an independent BI architect, specializing in data warehouse architectures based on SAP BW/4HANA, SAP HANA, Hadoop, and Spark. Thorsten began work as a MicroStrategy employee in 1997, developing applications for business intelligence. In 1999, he developed the first SAP RapidMarts solution (currently SAP BusinessObjects) based on SAP Business Information Warehouse 1.2B at Acta Technology in Silicon Valley. From 2002 to 2005, he worked as an SAP BI consultant and SAP BW trainer for SAP SE and SAP UK, in numerous projects in Germany and the UK. In 2006 he started a joint venture with Bill Inmon as a member of the advisory board and presented the results (BI Master Data Management) at SAPPHIRE 2007 in Vienna. This event marks the beginning of his company, BIPortal GmbH.

As a participant in the Strata conference in London in 2013, he decided to focus on data products because he could apply his experience in mathematical optimization, machine learning, and economics in this area. Thorsten studied economic informatics at the Technical University of Braunschweig. His diploma thesis presented the application of machine learning for business analytics, now a reality with SAP BW/4HANA.

Connect to SAP Analytics Cloud, SAP Data Warehouse Cloud, and more

· ... Preface ... 15

· ... Who This Book Is For ... 16

· ... How This Book Is Organized ... 16

· ... Data Model Download ... 19

· ... Acknowledgments ... 20

· 1 ... SAP BW/4HANA and Its Ecosystem of Tools and Services ... 21

· 1.1 ... What Is Business Intelligence and How Is It Related to Digitization? ... 22

· 1.2 ... Merging Data Lakes and Data Warehouses ... 24

· 1.3 ... SAP Business Warehouse Releases ... 27

· 1.4 ... Navigating SAP BW/4HANA ... 31

· 1.5 ... Deployment Scenarios ... 36

· 1.6 ... Related Cloud Technologies ... 45

· 1.7 ... Use Case of this Book ... 51

· 1.8 ... Summary ... 54

· 2 ... Architecture ... 57

· 2.1 ... The Evolution of the Layered Scalable Architecture (LSA++) ... 58

· 2.2 ... Business Intelligence Clients ... 67

· 2.3 ... Business Content ... 69

· 2.4 ... Data Protection Workbench ... 70

· 2.5 ... Multi-Temperature Data Management ... 72

· 2.6 ... Summary ... 77

· 3 ... Installation ... 79

· 3.1 ... Administering Instances in a Public Cloud Environment ... 79

· 3.2 ... Setting Up the SAP BW/4HANA Client ... 100

· 3.3 ... Installing SAP Business Planning and Consolidation, version for SAP BW/4HANA ... 127

· 3.4 ... Summary ... 138

· 4 ... Tools ... 139

· 4.1 ... SAP HANA Studio Installation and Configuration ... 139

· 4.2 ... SAP HANA Client Tool Installation ... 167

· 4.3 ... Enabling SAP BW/4HANA for SAP Analytics Cloud ... 171

· 4.4 ... Connecting to SAP Data Warehouse Cloud ... 176

· 4.5 ... SAP Data Intelligence ... 191

· 4.6 ... SAP S/4HANA Embedded Analytics ... 193

· 4.7 ... Summary ... 194

· 5 ... Security and Operations ... 195

· 5.1 ... SAP BW/4HANA Authorizations ... 196

· 5.2 ... Read Access Logging ... 212

· 5.3 ... SAP HANA Authorizations ... 223

· 5.4 ... SAP BW/4HANA Transports ... 258

· 5.5 ... SAP BW/4HANA Operations ... 266

· 5.6 ... Summary ... 273

· 6 ... Basic Data Modeling ... 275

· 6.1 ... Modeling Objects ... 275

· 6.2 ... Modeling Process Chains in the SAP BW/4HANA Cockpit ... 392

· 6.3 ... Master Data Modeling ... 401

§ 6.4 ... Hybrid Data Modeling with SAP HANA ... 412

· 6.5 ... Modeling for SAP Business Planning and Consolidation, version for SAP BW/4HANA (Embedded Configuration) ... 419

· 6.6 ... Summary ... 433

· 7 ... Advanced Data Modeling ... 435

· 7.1 ... Data Distribution ... 436

· 7.2 ... Virtual Data Modeling ... 447

· 7.3 ... Modeling CompositeProviders ... 466

· 7.4 ... Native SAP HANA Data Modeling ... 469

· 7.5 ... Data Modeling in SAP Data Warehouse Cloud ... 491

· 7.6 ... Remodeling Code with the ABAP Development Tools ... 508

· 7.7 ... Summary ... 515

· 8 ... Analytics Clients for Business Intelligence ... 517

· 8.1 ... SAP Analytics Cloud ... 517

· 8.2 ... SAP Lumira ... 572

· 8.3 ... SAP Analysis for Microsoft Office ... 584

· 8.4 ... Native BI Portal Applications with SAP HANA XSA and SAP Fiori ... 586

· 8.5 ... Third-Party Clients for the Mac ... 587

· 8.6 ... Microsoft Excel via MDX ... 596

· 8.7 ... Summary ... 599

· 9 ... Deployment Options ... 601

· 9.1 ... Conversion versus Transformation ... 601

· 9.2 ... Planning Your Migration to SAP BW/4HANA ... 602

· 9.3 ... SAP BW/4HANA in a Virtual Private Cloud ... 609

· 9.4 ... Greenfield Installation ... 623

· 9.5 ... In-Place Conversion ... 626

· 9.6 ... Summary ... 644

· 10 ... Roadmap ... 645

· 10.1 ... Data Distribution and Management ... 645

· 10.2 ... Data Protection Workbench ... 647

· 10.3 ... Process Chains ... 647

· 10.4 ... Performance Improvements ... 648

· 10.5 ... SAP Analytics Cloud Integration ... 648

· 10.6 ... SAP Data Warehouse Cloud Integration ... 648

· 10.7 ... Summary ... 649

· ... The Authors ... 651

· ... Index ... 653