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