Data Modeling with SAP BW/4HANA 2.0

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.

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.

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