SAP BI/BW
-by
Rahul Sindhwani
SCOPE/ AGENDA
What is BI ?
SAP BI
History of SAP BI
ETL Process
Architecture of SAP BI
Typical Data Flow in SAP BI
Data Model Info Object, Infocube(Star
Schema Extended Star Schema ,DSO etc
Business Explorer (Bex Analyser , Query
Designer)
What is Business
Intelligence?
Gathering
Storing
Analyzing
Providing Access to data
Make better Decisions
BI answers following
questions
What is the current status of the business?
Whats going well?
What needs improvement?
Yest
erda
y
No
w-
What are the business strengths and
weaknesses?
How do we improve our decision making?
Tom
orro
w
Business Intelligence Turns Data into
Knowledge
Decision
Knowledge
Information
Data
SAP BI
SAP BI Data Warehousing Solution by SAP
Flexible reporting and analysis tool for
evaluating and interpreting the data.
Business data integrated, transformed, and
consolidated in Sap BI.
History of SAP BI
SAP launched the product in 1997 by the
name Business information Warehouse (BIW),
Version 1. 2A
Product Name Changed to Business
Warehouse (BW) with version 3.0A
Named Business Intelligence BI with
version 7.0
Key Functionalities of SAP
BI
ETL (Extraction, Transformation, Loading)
Data Analysis & Planning
Tools for accessing and visualizing data
Publishing content from SAP BI
Performance
Security
BI Content
ETL Process
The process of the extracting data from
Source systems and making it useful for our
needs is ETL
Source Systems
SAP systems (S-API Service Application
Programming Interface)
BI systems
Flat files
Database management systems (DB Connect)
Relational or multidimensional sources (UD
Connect)
Web Services
Transformation
Direct assignment
Constants
Reading master data
Routines
Formula
Initial
DATA STORAGE
AND
DATA FLOW
Typical Data Flow in SAP BI
DTP
Transformation
2
Transformation 1
DTP
Infopacka
ge
DATASOURCE
Data Source is a set of fields that are provided
to transfer data into BI
1)DataSource for transaction data
2) DataSource for master data
PSA
The Persistent Staging Area (PSA) is the
storage area for data from the source systems
in BI.
The requested data is saved, unchanged from
the source system.
Starting point (entrance) of data into BI
system
DSO
A DataStore object serves as a storage
location for consolidated and cleansed data.
The data in DataStore objects is stored in
transparent, flat database tables.
This data can be evaluated using a BEx query.
Contain 1) Key Fields (Ex Doc number, item
etc
2) Data Fields
Dimensions
/Characteristi
cs
Determine the sales amount for customers located in New York
with Material Group ABC in the year 2011
Bex Query Designer
Bex Analyzer
Process Control in BW
Load into PSA
3
Drop Indices
2
Load into ODS
4
Start 1
Roll up
Aggregate
9
Activate
Data in
ODS
5
Build DB
Statistics
8
Data Target
Maintenance
Data
Load
Monitor
Further update
6
Build Indices
7
Advantages of SAP BI
Covers Major Business Processes
Simple access to business information via a
single point of entry
High performance environment.
Standardized structuring and display of all
business information
Major Differences between Sap
Bw 3.5 & sapBI 7.0 version
Infosets now can include Infocubes as well
Remodeling. This is only for info cube.
The BI accelerator (for now only for infocubes) helps in
reducing query run time
Search functionality has improved. You can search any
object.
The Data Warehousing Workbench replaces the
Administrator Workbench
THANK YOU
Transfer and Update rules replaced by
Transformation
Load through PSA has become a mandatory
Introduction of "end routine" and "Expert
Routine
Renamed ODS as DataStore.
Introduction of Write optimized DSo