SAP University Alliances Version 3.0 Authors Klaus Freyburger Tobias Hagen. SAP BW Data Modeling. Abstract: This chapter covers the basic aspects and concepts of data modeling with SAP Business Information Warehouse (SAP BW). Product SAP Netweaver 7.3 BI Level Undergraduate Beginner.
SAP NetWeaver Portal
Any Portal, Any Destination
SAP Business Intelligence - BI 4.0
Data Quality Mgmt
Data Quality Mgmt
Master Data Management
SAP NetWeaver BW on HANA
SAP NetWeaver BW / BW-IP
Data Quality Management
SAP Business Suite
3rd-Party Databases and Applications
Note: What SAP calls a Characteristic is often referred to in the data warehouse community as a Dimension.
SAP BW InfoObjects
SAP BW DataSource
SAP Business Information Warehouse!!
Amount, Quantity, .. …
Data Type: integer, float, char(10), …
EUR, USD, … (fix)
Pieces, inch, %, … (fix)
Unit / Currency (fix) / Currency reference
Jan Feb Mar Apr May JunKey Figure Definition: Revenue (cont.)
Aggregation: Last Value, Maximum, Average…
Reference Characteristic, e.g. Quarter
The reference characteristic allows the use of a function to aggregate data instead of summation.
Example: Number of Employees at the end of the quarter. Sum does not make sense!
Aggregation: Summation, Minimum, Maximum
If the Key Figure is non-cumulative (e.g., warehouse stock), this field defines an InfoObject representing non-cumulative change. This InfoObject is either positive or negative. So, the stock amount can be calculated from it.
Two fields are used to calculate the non-cumulative amounts. Inflow is the InfoObject which represents the stock inflow amount. Outflow is vice versa.
Data Types: Num, Char, Date, …
Transformation external internal format is performed by a conversion routine
An InfoObject may have attributes!
Usablefor OLAP operationsordisplayonly
5 steps to Define an DataStore Object
7 Steps to Define an InfoCube
Navigational attributes are InfoObjects which are used to perform data analysis.
Display attributes are InfoObjects for which data analysis does not make sense (e.g. a house number or a family name)
This has an impact to cube design!
Note: In data warehouse community, the term Dimension is used for what SAP calls Characteristic .
Characteristicaspartof a dimension
3. Navigation Attributes arereadytobeused in analysis.