SAP BW Online Training

Highlights in our training

• Very in depth course material with real time scenarios

• We are providing class with highly qualified trainer

• We will provide class and demo session at student flexible timings

• In training case studies and real time scenarios covered

• Each topic coverage with real time solutions

• We are providing normal track, weekend, fast track classes

• We will give every recorded session for play later

SAP BW 7.3/7.4 Online Training Course Content

Overview & Concepts

Types of Projects

SAP BW Overview

Basic Objects in SAP BW

BI Concepts & Overview

SAP-BI 7.0

7.0 Info Providers

• Analysis process Designer

• Modeling/Repartitioning

• Data Mart

• Open Hub Destination

• Infoset

• Multiprovider

SAP-BI 7.3

New Info Providers

Types of Info Cubes, Info Sets, MultiProvider

Business Content

Extraction

Process Chains

Transport Mechanism

Authorization Concepts

BI 7.0 Reporting

BEx Query Designer

Web Application Designer

• Creating Web Templates

• Web Item & properties

• Drop-down Functions

• Condition & Integration

Business Explorer Analyzer

Report Designer

Performance Improvement

• Aggregates

• Compression

• Partitioning

• Indexes and DB Statistics

• Number Range Buffering

• Read Mode & OLAP cache

• Line Item Dimension & High Cardinality

• Read Mode & OLAP cache

• Others

• Creating Reports

• Formatting columns & Rows

• Changing font styles with background color

• Inserting Rows & columns

• Introduction to BEx Analyzer

• Filtering Option

• Properties Available in Analyzer

• Introduction of BEx Query

• Filters, Columns & Rows

• Characteristic Restrictions & Free Characteristics

• Formulas & Calculated Key Figures

• Restricted Keyfigures & Variables with Texts

• Report to Report Interface or Jump Starts

• Query Extracts using RSCRM_BAPI

• Exceptions, Conditions, Structures, Cell Definitions and others

• Authorization

• Creating & Assigning Roles

• Review of system Landscape

• Collecting Objects

• Creating Transports

• Releasing Transport

• Importing Transport

• Monitoring Transport

• Types of Process Chains

• Real time scenarios from support projects

• Flat file Extraction

• ECC Standard Extraction

• In-depth workaround and implementation of LO extractors with a real time business scenarios

• Business Content Extraction

• Generic Extraction & Generic Delta

• Data Enhancements- Tables, View, Query

• Important of business Content

• Business Content Installation & Activation

• Business Content Data Source, DSO’s, Cubes, Reports, etc…

• Open Hub & Performance Issue

• Deleting data from data target

• Query performance & Load Performances

• Standard, SAP HANA-optimized DSO

• Semantically partitioned DSO

• Standard, with data persistence in the BWA

• Standard, SAP HANA-optimized Info Cube

• Semantically partitioned Info Cube

• Hybrid Provider Based on a DataStore object

• Hybrid Provider Based on direct access

• Composite Provider

• Standard DSO

• Write-optimized DSO

• Direct Update DSO

• Master Data – Attributes, Texts, Hierarchies

• Transaction data-Delta data loading

• Standard Info Cube

• Virtual Providers (Virtual Cubes)

• Infoset

• MultiProvider

• Aggregation Level

• Others

• Info Area ,Info Object Catalogs

• Info Objects(Characteristics & Key Figures)

• Application Component

• Data Source

• Transfer Rules

• Info Source

• Update Rules

• Different types of Routines

• Info Package

• Transformations

• Data Transfer Process(DTP)

• Error DTP

• Metadata Repository

• Modeling

• Extraction

• Reporting

• Real Time Implementation Projects

• Up-Gradation project

• Enhancements to the existing Implementation project

• Support project

• Overview of SAP R/3

• Necessity of SAP BW & Version of BW

• OLAP & OLTP

• Data Ware Housing Concepts

• Landscape of SAP BW

• Integration of BW system with different systems

• ERM, MDM, Star Schema & Extended Star Schema

​

Online and Classroom based courses:

                                    

BI/BW 7.0 BW 7.3 7.4 & BW POWERED by HANA

​

R/3 Architecture.

Landscape of SAP.

BW – Introduction, DWH Introduction

SAP Business Warehouse concepts and Overview

Different Source Systems

Star Schema and Extended Star Schema

Difference between OLAP and OLTP Processors

 

3.x Objects

Info area

Info object Catalog

Info Objects

Application component

Info source

Data source

Transfer rules

Communication structure

Update rules

Info Cubes

ODS

Info Package

 

7.X Objects

Info Area

Info Object catalog

Info objects

Data source

Source system

Application component

Data source

Transformations

Info Cube

DSO                                                       

Info package

DTP                                                                                         

 

Flat file extractions (3.x & 7.x)

Master data extraction

                Attribute

                Text

                Hierarchy

Transaction data                 extraction

                To DSO

                To Info Cube

                DSO to Info Cube

Data Flow difference between BW3.x and 7.X

Migration Strategyfrom BW3.X to BW7.X

Data mart concept.

 

Info Providers: (3.x & 7.x)

Info Objects

Introduction to InfoCubes

Types of InfoCubes .

Standard InfoCube

Real time Infocube

Virtual Providers

 

BI 7.0 BW 7.3 7.4 & BW POWERED by HANA(7.4)

 

ABAP for BW

Introduction to ABAP.

Creating Tables

Creating views

Concepts of Routines and Types of Routines

Field Level Routine, Start Routine, End Routine and Expert Routine

 

BI Content

Introduction to Meta Data Repository

Introduction to Business content

Grouping & Collection Mode options in BI Content

Finding proper Object in Business Content and Installing Objects.

 

REPORTING

BEx Query Designer &BExAnalyser.

Restrictions

Variables

Conditions

Formulas

Calculated key figures

Restricted key figures

Selections

Exceptions

Filters.

Free characteristic

Structures

Query monitoring

Navigational Attributes.

Display Attributes.

Assigning hierarchy to Query.

RRI

Publish a SAP BI Report

 

Extractions

SAP Business content – Extraction

Introduction to Business Content Extraction

Master data Extraction (Attribute, Text & Hierarchy Data)

Transaction data Extraction.

Generic extraction

Generic Data Extraction using-Table, View, Infoset Query& Function Module

Delta Setup in Generic extraction using Generic Delta (extraction Using Time stamp, calendar day, Numeric Pointer)

Logistic  Data Extraction

Introduction to Logistic Extraction.

Update methods  -  Direct delta, Queued delta& V3

Un serialized delta.

Controlling and Profitability Analysis Extraction

Functionality of Cost based & Account Based in CO-PA Extraction

CO-PA Extraction

 

Introduction to Datastore Object(DSO)

Types of DSO's .

Standard DSO

Direct-Update DS

Write Optimized DSO

Multi Providers & Info set

 

Analysis Process Designer

 

Transformations

Introduction to Transformations

Transformation Rule types (Direct assignment, Routines, Initial value, Time Distribution, No update, Constant, read master data, Read from DSO)

Transformation Rule Groups

 

Open Hub Destination

Destination As Table(Local & Application server)

Destination As Data Base Table.

Concepts of Info spoke(in 3.x)

 

Re-modeling

 

Error Stack

 

Process Chain

Introduction to Process Chain

Creating Master Data Process Chains

Creating Transactional Data Process Chain

Scheduling Process Chains

Creating Meta Chain

Monitoring process chains

Removing from schedule and rescheduling the process chains

 

Performance Management

Types of Performance Optimization Techniques

Backend or Data Loading Performance Techniques

Deleting Indexes.                             

Line - item Dimension&High cardinality

Aggregates & Collapse.

Partitioning & Re-Partitioning

DB Statistics

BI Performance Tuning Activities

 

Transportation

Introduction to Transportation.

BW system Landscape

Creating of Package and Transport requests

Collecting the objects in BW across the Landscape

Transporting the Objects across the BW Landscape

Deleting and re-importing Transport requests.

Finding transportation Logs and return cods.

Transportation error and Solutions

SAP BW 7.4

Features of BW 7.4 Powered by HANA

Overview SAP BW 7.4  on SAP HANA and further Roadmap

Eclipse based Modeling Tools

Maintenance Composite Provider

SAP HANA optimized Transformations.

 

SAP BW POWERED BY HANA

Introduction to HANA

Landscape

Features of HANA

SAP HANA-Optimized Data Store Objects

SAP HANA-Optimized Info Cubes

Consumption of SAP HANA models in BW on HANA Mixed Scenarios

 

 

UAT Activities in Real-Time.

 

How to Check BW system Before Go-Live

 

BW, BPC Integration Concepts.

​

​

BUSINESS OBJECTS ENTERPRISE XI/R4

SAP BOBJ WITH SAP INTEGRATION

COURSE CONTENT                                course duration-15-20days.

1)DWH Concepts

2) BUSINESS OBJECTS XI ARCHITECTURE

3 ) CENTRAL MANAGEMENT CONSOLE   

• USER,GROUP,FOLDER—CREATION &AUTHENTICATION

• SETTING USER PREFERENCES

• ACCESS CONTROLS

• SCHEDULING

4) USING BUSINESS OBJECTS BI LAUNCH PAD

• BI LAUNCH PAD–WEBDESKTOP OVERVIEW,FOLDERS AND CATEGORIES

• BI LAUNCH PAD  USING OBJECTS.

5) UNIVERSE DESIGNER & INFORMATION DESIGNER TOOL

• GETTING START WITH UNIVERSE

• SETTING UNIVERSE PARAMETERS AND OPTIONS

• WORKING WITH TABLES

• VIEW COLUMN VALUES

• WORKING WITH JOINS

• USING CONTEXTS

• SOLVING JOIN PATH PROBLEMS

• CREATING CLASSES AND OBJECTS

• WORKING WITH LIST OF VALUES

• FORMATING CELLS

• USING THE QUERY PANEL

• SETTING ACCESS RESTRICTIONS

• TESTING AND MANAGING THE UNIVERSE

• DEFINING UNIVERSE LEVEL  FILTERS

• LINKING OF UNIVERSES

• ADVANCED OBJECTS LIKE @SELECT,@WHERE,

• @PROMPT,@AGGREGATE_AWARENESS

 

6) BO XI-R/4 FEATURES

• AUTO GENERATED CLASSES AND OBJECTS BASED ON DIMENSION AND KEY FIGURES

• CREATING HIERARCHIES

• EXPORTING THE UNIVERSE

• DASHBOARDS USING INFOVIEW

• XCELSIUS REPORTS USING EXCEL SHEET

• CREATING THE CRYSTAL REPORTS BASED ON SOURCE INFOCUBES

• BW PUBLISHER INTEGRATIONS

7) QUERY AS WEB SERVICE(QAWS)

• USAGE OF QUERY AS WEB SERVICE

• HOW TO CONFIGURE AND USE

• VIEWING THE UNIVERSE AND WEBI REPORTS

• VIEWING THE CRYTAL XCELSIUS REPORTS

8) LIVE OFFICE

• INTRODUCTION

• HOW DATA CAN BE EXTRACTED USING LIVE OFFICE

• EXTRACTIONG DATA IN XCELSIUS USING LIVE OFFICE

9) WEBI RICH CLIENT(WEB INTELLIGENCE)

• REPORT CREATION

• UNDERSTANDING WEBI FUNCTIONALITIES

• WEBI DOCUMENT IN INFOVIEW

• BUILDING A SIMPLE QUERY

• DEFINING QUERY PROPERTIES

• RESTRICTING DATA WITH QUERY FILTERS

• MODIFYING A QUERY WITH PREDEFINED QUERY FILTER

• USING PROMPTS TO RESTRICT DATA ,COMPLEX FILTERS

• WORKING WITH REPORT PANEL

• VIEW DATA IN TABLES  AND CHARTS

• USING BREAKS AND CROSS TABS

• FORMATTING BREAK,CALCULATIONS,CROSSTAB AND REPORT FILTERS

• USING DEFAULT AND CUSTOM SORTS

• RANK THE DATA TO SEE TOP/BOTTTOM VALUES

• USING ALERSTS TO HIGHLIGHT INFORMATION.

• ORGANISING REPORT INTO SECTIONS

• PREPARING DOCS FOR PDFS

• DOCS FORMATTING

• EXPORTING DOCS FROM THE RICH CLIENT

• ACCESSING INFOVIEW

10) BO CRYSTAL REPORTS

• CROSS TABLE WIZARD

• OLAP CUBE REPORT WIZARD

• CONNCETION S WITH ODBL

• ADOS

• ORACLE SERVER

• UNIVERSAL CONNCETION

• REPORT HEADER,FOOTER DETAILS

• TEXT OBJECTS

• GROUPS

• SUMMARY ,CROSS TABLES

• SUB REPORTS

• INSERT LINES,BOX,PICTURES

• CHARTS,FORMULAS

• QUERY BASED REPORTS

• SPECIAL FIELDS

11) DASH BOARD BULDER  

• GETTING STARTED WITH DASHBOARD BUILDER

• CREATING CORPORATE DASHBOARDS USING DASHBOARD BUILDER

• ANALYZING DASHBOARD CONTENT

• CUSTOMIZING DASHBOARDS

12) BO XI-R/4  CONTENT

                            SAP BO BI PLATFORM 

•  SAPBI PLATFORM CENTRAL MANAGEMNT CONSOLE

• CENTRAL CONFIGURATION MANAGER

• SAP BUSINESS OBJECTS BI PLATFORM JAVA BI LAUNCH PAD

13) SAP BO INTEGRATION

              SAP CUSTOMIZATION

14)DASH BOARD DESIGNER

​

​

​

SAP BI Training -1 Month Course.

SAP BO-15-20 Days course.

SAP BW Powered with HANA-1 Month Course.

​

​

​

​

​

​