SAP BI Course

SAP Introduction:

• ERP Introduction

• Data Ware Housing Concepts

• Over View Concepts of BW

• Over view of SAP R/3 Types of Applications

• OLTP

• OLAP

• R/3 Architectures

• Landscape of SAP

• SD&MM Flows

MODELLING

• Difference between BW&BI

• Info object types:

• Star schema & Extended star schema

• Modeling & Extraction Objects

• Info area

• Info objects Catalog

• Info objects

• Data source

• Source system

• Application component

• Data loading using flat files

• Attribute data

• Text data

• Hierarchy data

• Transaction data

• Type of data sources:

• Master data

• Text data

• Transaction data

• Hierarchy

• Info package

• PSA

• DTP

• Types of info providers

• Multiprovider

• Infoset

• Infocube

• Infoobject

• DSO

• DSO

• Types of DSO

• 1.Standard dso

• 2.Direct update DSO

• 3.write optimize DSO

• DSO Tables:

• 1.Active data table

• 2.New data table

• 3.Change log table

• Performance Tuning

• Loading performance

• Adjusting Data packet size

• ABAP code optimization

• c.Delete indexes

• d.Delete application logs

• e.Loading master data before loading transaction data

• Query performance

• cube partition

• create indexes

• aggregates

• compression

• Multiprovider

• Line item dimension

• High cordinality

• Types of cubes

• Types of DTPS

• Re-modeling

• Re-partition

• Business content

• Transportation

• Open hub destination

• Routines

• Start

• Field

• End

• Expert

• Process chains

REPORTING:

• BEX TOOL INTRODUCTION

• Query Designer

• Analyzer

• wad

• Report designer

• RKF&CKFs

• Free characterstics

• Filters

• Local&Global structures

• Query properties

• Exceptions

• Conditions

• Variables:

• Char

• Text

• Formula

• Hierarchy

• Hierarchy node

• Processing Types:

• User entry/Manual entry

• Replacement path

• Customer Exit

• Sap Exit

• Authorization

• RRI

• Currency&Unit conversions

• Types of attributes

• WAD

• Report Designer

• Work Books

• Information Broadcosting

EXTRACTION

• Different source systems

• Categerizataion of data sources

• Replication of Data sources

• standard data source enhancement

• Custom data sources&different delta types

• Table

• View

• Function module

• LO Extraction&Different delta mechanisms

• COPA Extraction

• Abap Introduction

• Data Dictionary:

• Domain & data elements

• creating tables & enhancing standard tables

• Types of tables:

• transparent

• Pooled

• Clustered

• Types of views

• Help view

• projection view

• Maintenance view

• database view

• Reports

• Basics of Reports,

• Select Queries and its use.

• Performance tuning techniques

• Open SQL,

• Open & Close Cursor technique, Package Split concept and its use.

• How to write a BI-Abap real time Programs from scratch and Sample programs explanation.

REAL TIME SCENARIOS

• Product Issues

• Ticket Handling

• Ticket tool tracker

• Error handling