Creating Data Models using SAP BW/4HANA

Objectives

After completing this lesson, you will be able to:

  • Create a Data Model in SAP BW/4HANA

Physical Data Model in SAP BW/4HANA

One of the key features of SAP BW/4HANA is the extraction, loading, transforming and storing of data from any source system. This means we are able to retain the history. But we can also generate a log of all changes in the source data so that we can identify the before and after picture of any data source and report on the changes. Changes to the data are referred to as the delta. DataStore Objects (advanced) are used for delta handling, especially the model type Standard.

Launch the video to learn how a DataStore Object handles delta loading.

Finally, let's see an example how data is loaded from one level to the next in SAP BW/4HANA.

Virtual Data Model in SAP BW/4HANA

As with most modeling solutions, data models are creating using layers. A CompositeProvider is the top-most layer in SAP BW/4HANA and sits on top of the physical data models. The key role of a CompositeProvider is to combine the lower-level models using data modeling techniques such as union and join. The lower-level models can be physical models (ADSO) or virtual models (ODS Views). You can also add additional calculations and filters to generate the precise data set that is required by the business user. The following demonstration video explains how to use a Favorites folder as a starting point for modeling and how to create an Open ODS View and aCompositeProvider.

Once a data model is created we can then create a query on top. A query is not regarded as part of the data model and is parts of analytics. However, SAP BW/4HANA includes a powerful query tool that generates the analytical output that can be consumed by reporting tools.

Launch the video with a demonstration to learn how to define a BW Query with Filter and default layout on top of your data model.

Log in to track your progress & complete quizzes