SAP BW/4HANA 2.0 - The Comprehensive Guide

Ready for SAP BW/4HANA 2.0? Whether you're an architect, administrator, or developer, this comprehensive guide is for you. Start with a new installation or migrate from an existing SAP BW system. Then walk through major administration, security, and data management tasks. You'll learn to model data, convert ABAP transformations, use embedded SAP BPC for planning, connect to SAP Analytics Cloud, and more. The data warehouse of the future is here!

1. Deployment and Migration
Learn to install SAP BW/4HANA, step-by-step, or migrate from SAP BW. Implement SAP BW/4HANA in the cloud and on-premise.

2. Administration
Set up the tools you need to work with SAP BW/4HANA, from SAP HANA Studio to the ABAP Development Tools. Secure your system with authorizations, track user activity with read access logging, and automate data pipelines with process chains.

3. Modeling
Model your data within SAP BW/4HANA. Create and configure aDSOs, Open ODS views, CompositeProviders, and more. Master hybrid and native data modeling in SAP HANA, and take a closer look at modeling with SAP Data Warehouse Cloud.

4. Analytics and Business Intelligence
Connect to frontend analytics tools, from SAP Analytics Cloud to SAP Analysis for Microsoft Office. Explore dashboard design, report creation, and data discovery.
Highlights:

• Architecture
• Administration
• Installation and migration
• Tools and clients
• Authorizations
• Operations
• Data modeling
• Analytics
• SAP Data Warehouse Cloud
• SAP Analytics Cloud
• SAP Data Intelligence

List of contents

· ... 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

About the author

Marina Lüdtke is the managing director of BIPortal GmbH in Hamburg, Germany. Previously she worked as a sales representative for various chemical companies in Germany, East Africa, and South America. Using advanced analytics, she generated sales of over US$10 million annually. At BIPortal, she helps clients achieve the same success with BIPortal’s analytical tools and SAP Analytics Cloud on SAP BW/4HANA.

Summary

Ready for SAP BW/4HANA 2.0? Whether you’re an architect, administrator, or developer, this comprehensive guide is for you. Start with a new installation or migrate from an existing SAP BW system. Then walk through major administration, security, and data management tasks. You’ll learn to model data, convert ABAP transformations, use embedded SAP BPC for planning, connect to SAP Analytics Cloud, and more. The data warehouse of the future is here!1. Deployment and MigrationLearn to install SAP BW/4HANA, step-by-step, or migrate from SAP BW. Implement SAP BW/4HANA in the cloud and on-premise.2. AdministrationSet up the tools you need to work with SAP BW/4HANA, from SAP HANA Studio to the ABAP Development Tools. Secure your system with authorizations, track user activity with read access logging, and automate data pipelines with process chains.3. ModelingModel your data within SAP BW/4HANA. Create and configure aDSOs, Open ODS views, CompositeProviders, and more. Master hybrid and native data modeling in SAP HANA, and take a closer look at modeling with SAP Data Warehouse Cloud.4. Analytics and Business IntelligenceConnect to frontend analytics tools, from SAP Analytics Cloud to SAP Analysis for Microsoft Office. Explore dashboard design, report creation, and data discovery.

Highlights:

Architecture
Administration
Installation and migration
Tools and clients
Authorizations
Operations
Data modeling
Analytics
SAP Data Warehouse Cloud
SAP Analytics Cloud
SAP Data Intelligence

Product details

• Authors: Marina Lüdtke, Thorste Lüdtke, Thorsten Lüdtke
• Publisher: Rheinwerk Verlag
• Languages: English
• Product format: Hardback
• Released: 01.02.2021
• EAN: 9781493216352
• ISBN: 978-1-4932-1635-2
• No. of pages: 663
• Dimensions: 186 mm x 42 mm x 263 mm
• Weight: 1506 g
• Series: SAP Press; SAP PRESS Englisch
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Data communication, networks; Informatik, SAP BW/4 HANA, SAP BW4/HANA, SAP BW 4HANA, SAP BW4HANA, Save 15% with code APR15