myNotes from mySAP Learning

Theoretically, SAP BW Architecture can be divided into 3 layers: Sources System, SAP BW Server and SAP BW OLAP.

SAP BW Architecture

Read more… »

Data warehouse (including Business Information Warehouse – SAP BW) as analytical system or known as OLAP (Online Analytical Processing) system are fundamentally different compare to transactional system or known as OLTP (Online transactional Processing) system.

Here are the different between OLAP and OLTP: Read more… »

A modern data warehouse must meet the following requirements:

[source: Business Warehouse Course Handbook from mySAP.com]

Standardized structuring and display of all business information:

Decision makers urgently need reliable information from the production, purchasing, sales and distribution, finance, and human resources departments. They require an up-to-date and comprehensive picture of each individual business area and of the business as a whole. These results in high demands being put on the data collection process from the underlying data sources. An important aspect here is that the data is defined uniquely across the entire organization, in order to avoid errors arising through varied definitions in different sources. Read more… »

The first question while starting to learn SAP BW (Business Warehouse) is what Business Warehouse itself is.

If we talk about Business Informastion Warehouse, we can not avoid talking Data Warehouse because Business Warehouse is Data warehouse solution developed by SAP. The SAP BW system is an enterprise-wide information hub, which allows us to analyse data from R/3 and non-R/3 application and present it in an Excel-Based user interface. SAP BW enables us to analyze data from operative SAP Application, from others business application and external data sources such as databases, outline services or may be from internet. To circumvent the numerous disadvantages associated with reporting in the ERP system; data storage, management and reporting takes place on a separate server called the SAP BW Server. Read more… »