Friday 17 November 2017

BI in SAP remains for "Business Intelligence". Beforehand it was known as "Business Information Warehouse" ( BIW ). It is one of the main components of SAP Netweaver technology. An organization needs to play with their business data for more advancement and gainfulness and efficiency. The tools contained in SAP BI gives the facility for

  • Reporting
  • Analysis
  • Interpretation 

 What is SAP BI?

SAP Net Weaver, alongside with the intelligence of data warehouse and different business tools to accomplish long/short term goals, gives improved choices to testing business situations. Different components, for example, the reporting, scrutiny and other interpretation of business data are presently being controlled with the use of Business Intelligence (BI) tools. BI administrators are presently incorporating whole external data sources and internally placed SAP applications in the significant toolsets - in an outcome situated and simple way to determine the best outcomes.

Overview of SAP BI Architecture

Before we take in more about SAP BI Architecture, we should find out about

Conceptual Layers of Data Warehousing with BI

Persistent Staging Area

The data extracted from the Source Systems initially goes into the Persistent Staging Area. The data at this layer is the raw data which is in unaltered form. The data is consolidated and cleansed down just in the next layers.

The staging area is a brief table that holds the data and associated with a work area or truth tables. In the absence of staging area, the data load should go from the OLTP system to the OLAP system straightforwardly which hamper the execution of OLTP system.


Data Warehouse Layer (DWH Layer)

Data from the Persistent Staging Area is stacked into the Data Warehouse Layer. It has Corporate information repository. Data in this layer is put away for a more extended period.i.e, Entire History data (for instance, most recent 5 years data) is put away here in this layer.No reporting-relevant data; the granularity of the data put away in this layer is at line-item (point by point) level.


Operational Data Store Layer

Data is stacked to an Operational Data Store Layer often consistently from the source frameworks. Consequently, the data in this layer contains every one of the progressions to the data that was done for the duration of the day. Data from Operational data store later can be stacked to the Datawarehouse layer at specific timings to update the date in Datawarehouse Layer. This Operational Data Store Layer can likewise be utilized as a part of emergencies of any crises when the data in the data warehouse and datamart layers are lost. In such circumstances, data can be stacked from the Operational Data Store layer to the Data Warehouse Layer and Data Mart Layer. ODS did not depend on star schema model however they are in a flat files format.


Architected Data Mart Layer

Architected Data Mart Layer otherwise called Infocube. It is designed to store compressed and aggregated Data for long period of time. Data from the Data Warehouse Layer is stacked into the Architected Data Mart Layer. It is utilized for Analysis and reporting. The data is at a high level relevant for making reports showing these data. Data control with business logic is done at this layer. It comprises of a central fact table (Key Figures) encompassed by a few measurement tables, it is utilized to support BW queries.


SAP BI/BW Architecture:

BI has three-tier architecture:n:

Database Server: Where data is physically stored.( ODS, PSA, Infocube and metadata storehouse).

Application Server: The application server depends on the OLAP processor. It is utilized to recover data stored in the database server.

Presentation Server: Manages detailing and data access.

  1. Data is removed from the Source Systems.
  2. Data is organized in the Persistent Storage Area (PSA). This holds Source like data.
  3. Data is purified, loaded and stored in Data Store Object.
  4. Data is viewed at multiple dimensions in the Infocube.
  5. Data is accessible by the OLAP processor to the Business Explorer to show data according to Analysis necessities of the Business.
  6. Data can be influenced accessible to SAP/Non-To sap, Data Marts by the Open Hub Service. 


Vintage IT Solutions provide SAP Online Training Courses in India, USA, and UK. SAPVITS have an excellent facility of training. We provide Individual and Corporate training. SAPVITS provides Server Access Services. We provide SAP Remote Access and SAP Ides Access Services.
We mainly focused on

The SAP BI Course is suitable for Fresher’s wanting to get highly paid jobs. SAP BI BW Online Training is available in several approaches. Contact us for more details regarding SAP Online Training in Pune.

Contact us:

Email id:
USA: +1 678 389 8898
UK: +44 141 416 8898
IND: +91 992 284 8898