|
Contents:
1.0 Introduction
2.0 SAP’s BW Information Model: Overview
Data Sources
InfoSources
ODS objects
InfoCubes
InfoProviders
MultiProviders
3.0 Analytical View of Business Information
Warehouse Model
4.0 Building SAP BW into multi-tier
architecture model in Business Services
Components of BW architecture
Modeling Features
Fundamentals of ETL Service Architecture
Extraction at Service Levels
Components of ETL Services at Database of File Level
Understanding the role of storage services layers in architectural model
5.0 Analysis of BW support navigation
facilities integrated to BW 3.0
6.0 Challenges to the SAP Business Information
Warehouse
7.0 Outlook
Extracts:
Extract 1 -
SAP’s BW information
model is based on the core building block of InfoObjects which are used to
describe business processes and information requirements. They provide basis
for setting up complex information models in multiple languages, currencies,
units of measure, hierarchy, etc. The key elements in the SAP’s BW
information model are:
Extract 2 -
SAP’s BW is based on
“Enhanced Star schema” or “Info Cubes” database design. This database design
has a central database table, known as ‘Fact Table’ which is surrounded by
associated dimension tables. These dimension tables contain references to
the pointer tables that point to the master data tables which in turn
contain Master data objects such as customer, material and destination
country stored in BW as Info objects. An InfoObjects can contain single
field definitions such as transaction data or complex Customer Master Data
that hold attributes, hierarchy and customer texts that are stored in their
own tables.
Extract 3 -
SAP BW can be
integrated with other SAP components based on application programming interface
(API) service. It provides a framework to enable comprehensive data replication
based on data extractors that encapsulate the application logic. Data Extractor
fills the extract structure of data source with a data from data source and
offers sophisticated handling of changes. In addition to supporting extractors,
the service APIs also enable online access via RemoteCube technology and
flexible staging for hierarchies. On the other hand SAP provides an open
interface called Staging Business Application Programming Interface (BAPI) to
extract data from non-SAP sources.
|
