SAP BW performs a role of information hub for enterprise data. This is an optimal solution of SAP ECC and external data information analysis, it provides tools to support from data extraction to final analysis function for effective analysis so that it can provide reliable analysis reports, systematic management of business management KPIs or operational KPIs, and support effective decision making.

Feature

Content

Subject Oriented

● Minimize duplication data, and integrated data to share all business
● Data structures that is not depend on specific business function or application
● Integration data regarding to related data on the basis of enterprise common theme

Integration
(Integrated)

● Physical unified data structure
● Guarantee data consistency through data modeling
● Secure data integration through standardization of enterprise data

Time Variant

● Hold for long period of time, and trend analysis of the past and the present
● Understand data changes over time and create snapshot through history data

Nonvolatile

● Load data and access data regularly
● Save the snapshot without updating the changes of transactional system

Contents

Key role

Analysis

● Access necessary data from Data Warehouse, and provide Management View for decision making
● Provide diverse analysis tools that make diverse format of unstructured inquiry or multi-dimensional inquiry for users
   - Dashboard : Structured report for executive based on FLEX
   - BEx Analyzer : Provide unstructured report that makes diverse format or multi-dimensional analysis
     for Microsoft Excel based UI
   - Web Application Designer : Provide unstructured report that makes multi-dimensional analysis in Explorer
     for HTML based UI

BW Server

● Constitute subject-oriented modeling that is considering Scalability for user.
● Centralization and convenience of maintenance management
● OLAP Processor : An analysis engine of BW that makes data from Source System analysis as diverse form
● Metadata Repository : it is data about the structures that contain data, information for Data Warehouse implementation, operation and using materials
● Staging Engine : Data storage
● Open Hub Service : Available to transfer BW DATA to Target system

Data
Extraction

● Data extraction system which is the lowest level of BW
● Source System can be SAP ECC or Non SAP (External System, Legacy system, Oracle DB, IBM DB2, Excel File..) etc.

Expected effectiveness

Case diagram

Content

Using Recorded datafor several year

The most basic usage case that shows sales, profit and loss trend by years

Using internal andexternal data

Linkage data analysis not only internal data but also competitor information, major economic indicators, etc

Data integration by theme

Site map for analysis by task/ theme(ex: sales analysis, purchasing analysis, business cost benefit analysis)

Support analysis online

BEx Aanalyzer which is based on Microsoft Excel makes user analysis data that is stored in data warehouse without specific programing

Expected effectiveness by task