SAP-BI (7.0) online training

SAP-BI (7.0) online training with ECC (6.0)

Introduction
General Introduction. 
SAP introduction. 
Data warehousing/ BW/ BI Introduction 
Data Modeling 
OLAP v OLTP: The OLAP Concept and differences between OLAP and 
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

Overview:
Differences between 3.5 and 7.0 version.
Upgradation from BW 3.5 to BI 7.0
Project:
ASAP methodology
Functional specifications
Technical Specifications
Responsibilities of BI consultant (implementation & support 
project)
Unit testing