18 Jul

SAP BW BI has the below layers-each of which provide an unique functionality in the module. We shall describe in brief about the individual layers and the way they are used in the enterprise solution schema.

1) The ETL Layer (Extract, Transform and Load):  This layer is used for one of the fundamental tasks for a business warehouse-connecting to a specific data source. Here the layer is responsible for extracting data from a specified data source (Extract), applying transformation rules to get the extracted data  in into the required format (Transform) and finally loading the data into the Data Warehouse (Load).

2) Data Warehouse Area: This layer is involved in the actual storage of the data in different data structures such as InfoObjects, Data Store Objects, InfoCubes etc.

3) Reporting Layer: The reporting layer can be seen as a presentation layer of the SAP BW BI. It helps in accessing the data stored in the Data warehouse and presenting it in a required format and manner. It helps in generating user friendly reports and data visualization formats as required by the analysts for business needs.

4) Planning and Analysis Layer: The Planning and Analysis layer can be seen as a successor to the reporting layer and gives dynamic capabilities to the user while working on the reported data. It includes the ability to perform calculations, and simulations on the data set and helps in decision making.

The pre-defined business content in the SAP BW BI suite exists in the form of InfoCubes, Info Roles, queries etc. They have to be configured as per the specific requirement of the enterprise. The exhaustive collection of business content is what gives SAP suite its versatility and popularity in usage.

The article is just an introduction to the specific topic and is not intended to be a precise technical guide on the subject.