What is SAP BW and BI

What is SAP BW: – SAP BW (Business Information warehouse) is also known as BI (Business Intelligence). The following SAP BW training tutorials guides about “What is SAP BW” and its importance in SAP systems.

it provides the information that enables the organization to plan, track, manages, measure and optimize the performance. SAP BW is an end to end data solutions of data warehousing that is used in the pre-existing SAP R/3 systems.

What is SAP BW Architecture

Bw architecture has three layers such as

1. Reporting Environment: – The top lever is a Reporting Environment, it can be BW Business Explorer (also called as BEx) or any other reporting tools. BEx contains two types of components such as

  1. BEx Analyzer
  2. BEx Browser

2. BW Server: – It is the middle layer of architecture, the important functions of this layer is to administrate the BW system, data storage and retrieving the data as per users request.

3. Bottom layer: – It consists the source system that can be a SAP system, BW systems and other systems.

what is SAP BW- Business information warehouse

Steps involved in BW/BI

Modelling: – It is a arranging and shaping the data that is achieved by the cleaning, transforming and storing the data from different systems into a common location.

Extraction: – It is the process of extraction of data from non SAP system or SAP systems to Business Intelligence Server.

Reporting: – The data that loaded in to BI server can be easily extracted and analysed for better management decision making.

SAP BW and BI Versions history

The first version of SAP product for reporting, analysis and data warehousing was launched  in the year 1997 and called as Business warehouse information systems (BIW).

NameVersionRelease
BIW1.2AOct-1998
BIW1.2BSep-1999
BIW2.0AFeb-2000
BIW2.0BJune-2000
BIW2.1CNov-2000
BW3.0AOct-2001
BW3.0BMay-2002
BW3.1Nov-2002
BW3.1CApril-2004
BW3.3April-2004
BW3.5April-2004
BI7June-2005
BW7.3May-2011

 

SAP BW is built on the basis of 3 tier architecture and codes in the SAP ABAP language. IDOCs/ALE (Application Link Enabling) and BAPI (Business Application Programming Interface) are used to link SAP BW with SAP R/3 system or non SAP systems.

Types of Applications

  1. Online Analytical processing (OLAP)
  2. Online Transaction Processing (OLTP)

Now you are come to know what is SAP BW and BI and its importances.