SAP-BI (7.0) online training With Project
Trainer: suneel.sannala@gmail.com

Material:  Step by Step Screen shots material for complete 
course.
                 Audio & Video recorded sessions for complete 
course.
                 3 project videos.
                 3 videos related to BI with ABAP, 6 videos 
related to ABAP general syntax.
SAP- Books:  
                A Practical Guide to SAP NetWeaver Business 
Warehouse 7.0.
                ABAP Development for SAP BW -- User Exits and 
BAdIs
                Integrating SAP BusinessObjects XI 3.1 Tools 
with SAP NetWeaver.
                Using Crystal Reports with SAP.                

Introduction
General Introduction. 
SAP introduction. 
Data warehousing/ BW/ BI Introduction 
Data Modeling 
OLAP v OLTP
ERM, MDM, Star schema, extended star schema
Data warehouse workbench functions: Characteristics, Key 
Figures, Data Sources for 
 File Source Systems, Info Package, PSA, Transformations, data 
transfer processes
InfoCubes: Standards, real time, Virtual Providers
Data Store objects (DSO):  Standards, direct update, write 
optimized
Infocube VS DSO 
Master data- texts, Attributes, Hierchies.
Remodeling
Infosets
Multiprovider
Open hub destination
Process chains 
Metadata and Document Management 
BI Content: Definitions, How to install BI contents
Defining extraction 
For SAP source systems: Creating Generic dataSource and 
maintaining SAP delivered dataSource. 
Or for files: Creating DataSources for File Source Systems 

User management: 
Authorizations
Transports: 
Real business scenarios on different system environments, 
Moving objects from one system to another.  
Data Extraction:
Business flow: SD, MM, PP, FI.
BW overview –R/3 extraction
Generic data extraction 
Data Extraction from LIS
Data Extraction from LO cockpit
Data Extraction from CO-PA
Data Extraction from FI
Delta Management
BEx Query Designer :
Introduction to BW-Bex reporting (Bex analyzer, query designer, 
report designer, web application designer)
Reporting features & properties
Rows, columns, Free Characteristics, Filters,
 Exceptions, Conditions,
Calculated and Restricted Key Figures, structures.
Cell Definition New selection, new formula.
Column&row properties.
Query properties
Report-to-Report Interface
Variables: (5 types)
 Characteristic value variables, 
 Hierarchy Variables, 
Hierarchy node variables, 
Text variables, 
Formula variables 
Query designer
Information broadcasting
Design mode (web items)
Web application designer 
Performance 
Line item dimension 
High cardinality
Aggregates
Partition,Compression,Indexes,Olapcashe.
ABAP (related to BI)
Data source enhancements 
Start routine
End routine
Characteristics routine
Customer exit. (Reporting)
Additional:
Differences between 3.5 and 7.0 version.
Upgradation from BW 3.5 to BI 7.0
IP( Integrated Planning)
Business Objects with BI integration (theory) 
Common Data loading errors.
Project:
ASAP methodology
Functional specifications
Technical Specifications
Responsibilities of BI consultant (implementation & support 
project)
Unit testing & Integration testing