Analysis of BW support navigation facilities integrated to BW 3.0

OLAP BAPI: SAP BW 3.0 comes with the OLAP BAPI Interface (OBI) which provides functions that can be used by third party reporting tools to access BW Info cubes. It provides an open interface to access any information that is available through OLAP engine.

Integrating with XML: OLAP BAPI serves as the basis for the SAP implementation of XML for analysis. It is an XML API based on Simple Object Access Protocol (SOAP) designed for standardized access to an analytical data provider over the web. The XML interface introduced with SAP BW 3.0 release accepts XML data streams compliant with the SOAP. Unlike all other SAP BW interfaces in XML interface the actual data transfer is initiated by the source system.

Understanding the role of storage services layers in architectural model

* Master data manager: Master Data Manager generates the master data infrastructure containing master data tables as well as master data update and the retrieval routines. It also maintains master data and provides access to master data for use by SAP BW reporting components and for exporting to other data warehouse services for analysis and access services.

Components of ETL Services at Database of File Level

* Operational Data Store: It stores detailed data and supports tactical, day-to-day decision making. A SAP view ODS as a near real-time informational environment that supports operational reporting by interacting with existing transactional systems, data warehouses, or analytical applications. SAP BW allows flexible access to data in the ODS, the data warehouse, and the multidimensional models.

Fundamentals of ETL Service Architecture

ETL service comprises of two parts: Staging engine and Storage Service. Staging engine manages staging process for all data received from several source systems. It interfaces with the AWB scheduler and monitor for scheduling and monitoring data load processes. However, Storage Service manages and provides access to data targets in SAP BW and the aggregates that are stored in relational and multidimensional database management systems.

The administration services in SAP BW can be availed through Administration Workbench (AWB). It is a single point of entry for data warehouse development, administration and maintenance tasks in SAP BW with Metadata modeling component, scheduler and monitor as its main components as described in the figure hereunder:

Building SAP BW into multi-tier architecture model in Business Services

Being implemented on top of SAP Web Application Services SAP’s BW provides a multi-tier architecture (figure shown below), along with a complete software development environment, system management tools and additional functionalities such as currency conversion or security. Although it is closely related to SAP R/3, SAP BW is a completely separate software package which comes with automated extraction and loading facilities.

Analytical View of Business Information Warehouse Model

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.

SAP’s BW Information Model: Overview

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:

Introduction

In the fiercely increasing competition amongst corporations it has become mandatory to make quick and sound crucial business decisions based on analysis of business critical data. This is the point where data warehouses come into play. Although many companies are relying on data warehouses, they are still struggling to achieve positive results due to fragmented and inconsistent data. For them SAP’s Business Information Warehouse (BW) provides a complete information factory solution. BW is the central component in the SAP suite of applications with an added advantage of being a software package that can be used in both SAP and non-SAP environments.