SAP BW - Overview

SAP BW - Overview

Relational & Multidimensional Analysis

Delivered Reports (aka Business Content)

Ad hoc or Predefined (can be designed by users)

Significantly Faster Processing

Current (according to update schedule) & Historical Analysis

Cross Functional

The Business Information Warehouse (BW) is SAP’s architectural solution for data warehousing. 

1.       Seamless integration with R/3

2.      Built-in functionality that substantially reduces DW design, development and maintenance

BW is a separate system from the R/3 transaction processing system

1.       BW data structures are optimized for reporting data efficiently and quickly (analytical processing).

2.      R/3 data structures are optimized for recording data efficiently and quickly (transaction processing).

BW Reporting Tools Business Explorer (BEx) Query Designer

1. MS-Excel-Based Analyzer (Web or GUI)
2. Formatted Reporting
3. Web Application Designer

Business Explorer (BEx) Analyzer

Queries and solution workbooks embedded in MS Excel

Excel functionality can be utilized (calculations, charts, VBA programming, etc.)

Queries are refreshed at each run; workbooks provide pre-calculated queries

Incorporates BW Security and, therefore, eliminates the need for an additional layer of security at the reporting level

Seamless integration with BEx Analyzer for the Web

You may check here for SAP BW Courses