SAP BW/BI

SAP BW/BI Online Training

Introduction To Data warehouse:

• Data warehousing/ BW/ BI Introduction

• Overview of SAP R/3

• Importance of SAP BI.

• Versions of  SAP BI

• Data Ware Housing Concepts

• SAP System Landscape

• OLTP vs. OLAP

• SAP BI Architecture

• Star Schema Concepts – Star Schema Vs   Extended Star Schema

• Enterprise Data Warehouse Modeling:

• Objects in SAP BI

• Info Area, Info Object Catalogs

• InfoObjects: Definitions

•         - Types: Characteristics, Key Figures, Time, and Unit

• Data Loading Using Flat files - Master Data & Attributes ,Text Data , Hierarchies Data

• Transaction Data  

• PSA, Transformation

• Creation of InfoCubes

BI SUITE: Reporting

• Introduction

• BEx Web Application Designer

• BEx Report Designer

• Rows and Columns

• Free Charsterstic  & Filters

• How to create Queries.

• How to Restrict Characteristics,                                           

• Formulas

• Exception Cells

• Query Design:

• Defining Exceptions,

• Conditions,

• Restricted  Key Figures

• Calculated KeyFigures

• Variables: 

• Variable Types(Characteristic Variable, Text Variable , Formula Variable, Hierarchy Variable &  Hierarchy Node  and its Processing Types,

• Component Properties:  

• Properties of Characteristics,  Attributes, KeyFigures Properties, Global Query Properties, Copying queries between Cubes, Deleting Query Elements

ETL: Extraction Transforming & Loading

Generic Extraction - 

•    Table

•    View  

•    Infoset     

•    Function Module

          LO Data Extraction –  Customization & Migration Steps

          Non - LO Extraction

          Update Types :  Direct Delta ,Queued Delta Serialized & unsterilized V3 Update

           COPA Extraction

           FI-GL, AP, AR, & FI-SL Extraction

           Data Source Enhancement  for LO & Non LO.

Advanced Modelling Topics in SAP BW/BI

InfoCubes: Definitions - Types: Standards, real time, remote Cube

DataStore Objects (DSO): - Types: Standards, Write optimized DSO, Direct update DSO

InfoSets

MultiProviders: Scenarios to create

Infocube VS DSO

Metadata and Doc Management:

• BI Content: Definitions, how to install BI contents

ABAP for SAP BW/BI Consultant

• Field level Routine

• Start Routine

• End Routine

• Expert Routine

• Info package level Routine

Process Chains

• Introduction of  Process Chains , Process Types & Groups .

• Meta Chain

• Direct & Background Job scheduling

• Monitoring Process Chains

• Message Integration – Success, Error Message

• Including Delete, create indexes

• Scheduling & Cancelling Process Chains

• Scheduling Process chain in background

• Process Chain Monitoring Techniques How to Schedule Process Chains daily, weekly, monthly

 Transport Connection

• System Landscape: - Collecting Objects, Create Transport request, Releasing transport request,  Importing Transport request  & Error handling, Project Types

Performance Optimization:

Loading Performance

AggregatesCompressionPartitions,Line Item DimensionIndexes

Query Performance

Modeling ConceptsQuery DesignPartitioningCompressionAggregatesQuery Read Mode

Implementation Project

• Project Plan/ Preparation

• Business Blue Print

• Requirement Gathering (URS & FRS )

• Development

• Production

• Technical & Functional Specs

Support Project

• Monitoring Techniques (Daily, weekly & Monthly jobs)

• Handing Tickets

• Various Support Issues & its resolution

• Standard Naming convention in SAP- BI

• OSS Note &  Discussion Groups

SAP BW/BI Certification Guidelines

Guiding for SAP BW/BI  Certification - Sample questions and documentation for HANA certification provided.

Guiding Resume Preparation & Tracking Interviews