Data Modeling with #BW4HANA

Teulada-Palmeras

One of the most striking differences between BW and BW/4HANA is data modeling. On one hand, there is less but more versatile objects to choose from (see figure 1). On the other hand, there is a new, more intuitive alternative to BW’s long standing admin workbench (RSA1), namely the Data Flow Modeler (see figure 2). It shows physical and virtual containers (like DSOs or composite providers) as boxes. Data transformations, combinations, transitions etc. are indicated as directed lines between those boxes. From those boxes and lines it is possible to access the respective editor for those objects. In that way, a DW architect can navigate along the paths that the data take from entering the system towards the multidimensional views that serve as source to pivot tables, charts and other suitable visualisations. This is not only great for the mentioned DW architect but also allows for rapid prototyping scenarios, e.g. when a DW architect sits down with a business user to quickly create a new or modify a given model. Figure 3 shows an example.

Modeling-DW Modeling-BW4
Figure 1: Less and more logical objects when architecting a DW with BW/4HANA.
dataflow modeler 1

Figure 2: The new Data Flow Modeler in BW/4HANA.

dataflow modeler 3 dataflow modeler 4
Figure 3: The same scenario, once in the traditional admin workbench (left) and BW/4HANA’s Data Flow Modeler (right).

This blog has also been published here. You can follow me on Twitter via @tfxz.

Advertisements

2 thoughts on “Data Modeling with #BW4HANA

  1. Pingback: SAP BW/4HANA | sap analytix

  2. Pingback: What is #BW4HANA? | @tfxz

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s