Courses

SAP BI / BW

Course: SAP BI 7.0/BW 7.3, ABAP
Duration: 50 hours
Highlights of our training:

Real time Industry Experienced Trainer.

Interactive Training session using web conferencing tool
Normal track, weekend and fast track classes according to convenience
Student will be provided session recording capability to record each session
We provide Training Material, Exercises and Real Time Examples
Resume preparation and Certification Guidance
We will provide class and demo sessions at student flexible timings.
In training case studies and real time scenarios covered.

Introduction to SAP Business Intelligence

 SAP Net weaver BI Architecture / BI Platform

 Star Schema and Extended Star Schema

 Multidimensional modeling

 Entity Relationship Modeling

 Enterprise Data Modeling

 Enterprise Reporting, Query and Analysis

 SAP BW vs Other Data warehousing Tools

 Data Acquisition / Data Extraction concepts

SAP BW Phases

 Modeling

 Extraction

 Reporting

Modeling

 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

BI 7.0 Info Providers

 Master Data – Attributes, Texts, Hierarchies

 Standard DSO

 Write-optimized DSO

 Direct Update DSO

 Standard Info Cube

 Virtual Providers

 InfoSet

 MultiProvider

 Aggregation Level

 Others

 Open Hub Destination

 Analysis Process designer

BW 7.3 Info Providers

 SAP NetWeaver BW 7.3 Features Overview

 Graphical Data Modeling

 Graphical Data Flow Modeling Basics

 Data Flow Copying

 Data Flow Generation

 Data Flow Migration

 Advanced InfoProviders

 Semantically Partitioned Object (SPO)

 Hybrid InfoProviders

 Transient Providers

 The New BW 7.3 Hierarchy ETL

Business Content

 Importance of Business Content

 Business Content Installation & Activation

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

Data Acquisition / Data Extraction

 Flat file Extraction

 Business Content Extractions using MD/TD SD,MM and FI

 Logistics Extraction

 Generic Data Extraction using MD/TD Tables

 Delta mechanism

 CO-PA Extraction

 FI-SL Extraction

 Data source Enhancement

Process Chains

 Process Chains, Process Types

 Scheduling

 Monitor (Header, Status, Details)

 Real time scenarios from support projects

Transport Mechanism

 Review of system Landscape

 Collecting Objects

 Creating Transports

 Releasing Transport

 Importing and Monitoring Transport

Reporting

 Introduction of Various Reporting Tools

Functional Overview of Business Explorer Query Designer

 Introduction of BEx Query

 Reusable Query Elements

 Filters, Columns & Rows

 Characteristic Restrictions & Free Characteristics

 Formulas & Calculated Key Figures

 Restricted Keyfigures and Variables with Texts

 Report to Report Interface or Jump Starts

 Query Extracts using RSCRM_BAPI

 Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer

 Introduction to BEx Analyzer

 Filtering Option

 Properties available in Analyzer

Performance Improvement

 Aggregates

 Compression

 Re-Modeling

 Re- Partitioning

 Indexes and DB Statistics

 Number Range Buffering

 Read Mode & OLAP cache

 Line Item Dimension & High Cardinality

 Read Mode & OLAP cache

 Business Warehouse Accelerator

 Others

Types of Projects

 Real Time Implementation Projects

 Up-Gradation project

 Enhancements to the existing Implementation project

 Support projects

Introduction to SAP ABAP

 What is SAP

 SAP Architecture and where ABAP fits in

 ABAP Development Workbench Tools

 Object Navigator

 Workbench Organizer

 Data Dictionary

ABAP Dictionary

 Tables

 Views

 Lock Objects

ABAP Programming Techniques

 Reports Statement

 Line Size

 Line-count

 Message

 Page Heading

 Report Comment Section

 Declarations

 Tables

 Includes

 Variables (Data Types and Data Objects)

 Structures

 Internal Table

 Constants

ABAP for SAP BI Consultant:

 Field level Routine

 Start Routine

 End Routine

 Expert Routine

 Infopackage level Routine

 DataSource Enhancements

live Chat