SAP BI and SAP BW

Course Contents

ERP BI (Duration: 40-45 hrs)

SAP BI  Syllabus

  1. SAP Net weaver Business Warehouse – Overview

1.1 Evolution

1.2 Layers

1.3 Basic Navigation

1.4 Workbench Functions

1.5 Landscape

 

2 Info Objects and Master Data

2.1 Types Of InfoObjects

2.2 Creating an InfoArea

2.3 Creating & Configuring InfoObject Catalog

2.4 Creating & Configuring a Characteristic InfoObject

2.5 Creating & Configuring a Key Figure InfoObject

2.6 Creating a Unit InfoObject

 

3 DSO’s

3.1 An Introduction

3.2 Types of DSO’s

3.3 Architecture

3.4 DSO Design & Configuring

3.5 Advantages & Disadvantages of DSO’s

 

4 Infocubes

4.1 Modeling InfoCubes

4.2 The Schemas

4.3 Types of InfoCubes

4.4 Creating & Adding Dimensions

 

5 InfoProviders

5.1 Introduction

5.2 Design

5.3 Infosets

5.4 Creating an Infoset

5.5 Joins

5.6 Virtual Providers

 

6 Extraction, Transformation and Loading

6.1 Transformation

6.2 Loading Master Data

6.3 Creating Source System

6.4 Creating a DataSource

6.5 Creating a DTP

6.6 Creating an InfoPackage

6.7 Data Extraction

6.8 Monitor PSA

6.9 Monitor DTP

6.10 Loading Transactional Data

6.11 PSA & Error Stack

 

7 Extraction from SAP source system

7.1 Bi Content

7.2 Activation of bi content

7.3 Data extraction using Lo – cockpit

7.4 Extraction modes

7.5 Update modes

7.6 Generic extraction

7.7 Creating, configuring a generic data source

7.8 Extraction Queues

 

8 BEx Query Designer

8.1 Tool Landscape

8.2 Creating a simple BEx query

8.3 Defining filters

8.4 Define rows & columns

8.5 Executing the query

8.6 OLAP Variables

8.7 Types of variables

8.8 Processing types

8.9 Variable editor

8.10 Structures

8.11 Selections & Formulas

8.12 Conditions & Exceptions

 

9 Administration & Monitoring

9.1 DSO Administration & Maintenance 9.2 Info cube administration & Maintenance

9.3 Aggregates

9.4 Compression

9.5 Process Chains