SAP-BI (7.0) online training With Project
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
Additional:
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)
Project:
ASAP methodology
Functional specifications
Technical Specifications
Responsibilities of BI consultant (implementation & support project)
Unit testing
