SAP-BI (7.0) online training With Project
Data warehousing/ BW/ BI Introduction
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.
Open hub destination
Metadata and Document Management
BI Content: Definitions, How to install BI contents
For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource.
Or for files: Creating DataSources for File Source Systems
Real business scenarios on different system environments, Moving objects from one system to another.
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
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,
Calculated and Restricted Key Figures, structures.
Cell Definition New selection, new formula.
Variables: (5 types)
Characteristic value variables,
Hierarchy node variables,
Design mode (web items)
Web application designer
Line item dimension
ABAP (related to BI)
Data source enhancements
Differences between 3.5 and 7.0 version.
Upgradation from BW 3.5 to BI 7.0
IP( Integrated Planning)
VC (Visual Composer) theory
Business Objects with BI integration ( theory)
Responsibilities of BI consultant (implementation & support project)