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, HR.
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 & Bex Browser
Reporting features & properties
Free Characteristics, Filters, Exceptions, Conditions, Calculated and Restricted Key Figures, structures.
Cell Definition New selection, new formula.Column&row properties.
Report-to-Report Interface
Variables: Characteristic value variables, Hierarchy Variables, Hierarchy node variables, Text variables, Formula variables
Report designer
Information broadcasting
Design mode (web items)
Performance
Line item dimension
High cardinality
Aggregation, Rollup.
Partition
Compression
Indexes
Reconstruction
Overview:
ABAP (related to BI)
BI-IP (Integrated Planning)
Differences between 3.5 and 7.0 version.

Contact details

• Email: Click here to reply to this ad

Anti spam: Do NOT contact me offering services or anything of a commercial nature.