SAP BW 3.5 WITH BI 7.0

DATA WAREHOUSE OVERVIEW

Understanding Data warehousing Methodology.

OLTP vs. OLAP.

DSS Functionality.

Requirement Analysis of BW.

Versions of BW

INTRODUCTION TO BW/BI

Overview of SAP R/3 Environment

BW/BI Architecture

Landscape of BW

ERM

MDM

Star Schema

Extend Star Schema

Fundamental differences between above models .

SID Tables

Dimension Tables

Fact Tables.

DATAWARE HOUSE WORK BENCH

Administrator Workbench (BW3.x) vs. Data ware House Workbench (BI7.x)

Functionality of Data ware House Workbench.

Modeling

Administration

Transport Connection

BI Content

Translation

Metadata Repository

SAP BW/BI DATA MODELS

Info Area

Info Object Catalogue

Info Objects:

Characteristics: Display, Navigational, Transitive, Compounding Attributes

Key Figures: Cumulative and Non-CumulativeKey Figures

Info Cube

ODS (BW3.x) vs. DSO (BI 7.x)

Requirement Analysis of DSO

DSO Types: Standard, Write Optimized, Direct Update

Virtual Providers vs. Data Targets

Data Mart Concept

Multi Providers

Info sets

Virtual Providers

Aggregation Levels

Info Cube Types: Standard vs. Real time info cube

Basic vs. Virtual Providers

FLAT FILE DATA EXTRACTION

Maintaining Data source

Managing PSA

Maintaining Transformation

Maintaining Info source

Maintaining D.T.P

Maintaining Info Packages

   BI CONTENT

Understanding BI Content Requirement

Identify BI Content

Install BI Content - Delivery to Active Version

Precautions while Installing

Customizing Business Content

Usage of Best Practice’s

SAP R/3 EXTRACTOR Using BW3.x And BI 7.x ETL Process

SAP R/3 Reporting vs BW Reporting

Configuring R/3 Connection

Types of R/3 Extractors

BI Content Extractor

Extracting Master data, Text Data, Hierarchy Data and Transaction Data

Generic Extractor

LO Cockpit

CO-PA Extractors

FI-SL Extractors

Enhancement of Standard Data source.

Writing Enhancement Code in Customer Exit

Real Time Data Acquisition

Data Reconciliation

Extract Checker

Delta Que Maintenance

Real Time Scenarios, Functional and Technical Specs & Project Work

TRANSFORMATIONS

Transformation Types

Using Routines in Transformations

Start Routine

Expert Routine

End Routine

Currency CONVERSIONS

BW/BI REPORTING

Introduction to BEX components.

Query Designer

Query Elements

Filters, Structures, Selections, Formula’s, Restricted Key figures, calculated

Key figures, Hierarchies, Exceptions, Conditions, Variables, Variable Types,Variable processing types

BEX ANALZER

Bex Web Analyzer

Properties of Query’s

Work Books, Query Views

Designing work books

Report to Report (R/RI) Interface

BEX WEB Application Designer

Web Items

Properties, creating simple web Templates,Creating Dash Boards,

 

Support Activities

Aggregates,

BIA

Maintain Info cube

Maintain DSO

Attributing Change Run

Process Chains

Load monitoring

Query Monitoring

Analyze & Repair Database Objects

Statistics

production support issues while Monitoring Data Loads