Data Modeling with SAP BW/4HANA 2.0: Implementing Agile Data Models Using Modern Modeling Concepts

by Konrad Zaleski

Overview

Gain practical guidance for implementing data models on the SAP BW/4HANA platform using modern modeling concepts. You will walk through the various modeling scenarios such as exposing HANA tables and views through BW/4HANA, creating virtual and hybrid data models, and integrating SAP and non-SAP data into a single data model.

Data Modeling with SAP BW/4HANA 2.0 gives you the skills you need to use the new SAP BW/HANA features and objects, covers modern modelling concepts, and equips you with the practical knowledge of how to use the best of the HANA and BW/4HANA worlds.

What You Will Learn

• Discover the new modeling features in SAP BW/4HANA
• Combine SAP HANA and SAP BW/4HANA artifacts
• Leverage virtualization when designing and building data models
• Build hybrid data models combining InfoObject, OpenODS, and a field-based approach
• Integrate SAP and non-SAP data into single model

Who This Book Is For

BI consultants, architects, developers, and analysts working in the SAP BW/4HANA environment.

Product Details

ISBN-13:	9781484270882
Publisher:	Apress
Publication date:	08/19/2021
Edition description:	First Edition
Pages:	273
Product dimensions:	6.10(w) x 9.25(h) x (d)

About the Author

Konrad Załęski graduated from Warsaw University of Technology getting his master’s degree in management. After finishing his studies, he continued his education and completed two postgraduate courses in management information systems (Microsoft) and integrated information systems (SAP).

Konrad gained his experience by delivering business intelligence solutions for multiple global corporations. The majority of the projects from his portfolio were implemented on top of the SAP HANA, SAP BW/4HANA, and Microsoft BI platforms. He is also an active contributor and publisher in the SAP community.

Table of Contents

Chapter 1: Modeling objects
Subtopic:
1.1. Modern data modeling
1.1.1. Overview of SAP BW4HANA modeling concepts
1.2. Main SAP HANA Objects used for modelling
1.2.1. Calculation View
1.2.2. Table Function
1.3. Main SAP BW4HANA Objects used for modelling
1.3.1. InfoObject
1.3.2. Open ODS
1.3.3. Advanced DSO
1.3.4. Composite Provider
1.3.5. Query
Chapter 2: Publishing external data in BW4HANA
Subtopic:
2.1. Scenario
2.2. Smart Data Acess (SDA)
2.3. Creating virtual tables
2.4. Publish HANA tables through BW4HANA
2.5. Publish HANA views through BW4HANA
2.6. Pass input parameters from Query to Calculation View
2.7. Pass input parameters from Query to Table Function
2.8. Summary
Chapter 3: Creating virtual BW4HANA model
Subtopic:
3.1. Scenario
3.2. Create Master Data OpenODS views
3.3. Create Transactional Data OpenODS views
3.4. Create Composite Provider consuming OpenODS views
3.5. Create Query
3.6. Summary
Chapter 4. Converting virtual structures into persistent BW4HANA model
Subtopic:
4.1. Scenario
4.2. Materialize data model based on OpenODS
4.3. Summary
Chapter 5: Creating hybrid data model in BW4HANA
Subtopic:
5.1. Scenario
5.2. Create data model combining OpenODS, InfoObjects and raw fields
5.3. Summary
Chapter 6: Combining SAP and non-SAP data into single data model
Subtopic:
6.1. Scenario
6.2. Create view combining SAP and non-SAP data
6.3. Create OpenODS views for whole data set
6.4. Create Composite Provider
6.5. Join additional objects in Composite Provider
6.6. Create calculated fields on Composite Provider
6.7. Summary