SAP BI/BW ONLINE TRAINING:

Course Content:

INTRODUCTION

Overview & Concepts

  • Overview & Concepts
  • 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.

Objects in SAP BW

  • Info Area, Info Object Catalogs
  • Characteristics
  • Key Figures-Cumulative & Non Cumulative
  • PSA- Transfer Structure/Data sources
  • Transfer Rules
  • Info Source/Communication Structure
  • ODS- Info Cubes
  • Types of Info Cubes- Update Rules

Data Loading Using Flat Files

  • Master Data \96 Attributes, Texts, Hierarchies
  • Transaction data-Delta data loading

Data Filtration Techniques

  • Transfer Rules level
  • Update Rules level
  • Start Routines

PSA-Maintenance scheduling the data

  • Data Packet by Packet
  • Complete scheduling
  • Scheduling in background
  • Transfer Rules & Update Rules
  • PSA-Processing Types
  • Monitoring & scheduling data loading
  • Scheduling the jobs on periodic values
  • Cancellation & Deleting the back ground jobs

SAP-BI 7

    v
  • Bi Concepts & Overview
  • Modeling: Data warehousing workbench
  • Components of data warehousing workbench
  • InfoObjects, data source
  • Types of DSO\92s , Data Source Repository
  • Migration of 3.X data sources & Recovery of 3.X Data sources
  • Difference between ODS & DSO
  • Data Loading \96 Master Data & Transactional Data.
  • Concepts of Transformation & Its Types
  • Controlling the data-flow with Infopackages (IP)& Data Transfer Process (DTP)
  • Data Loading into DSO & InfoCubes
  • Standard \96Direct DSO \96Write Optimized DSO.

Types of Info Cubes, Info Sets, MultiProvider

  • Open Hub & Performance Issue
  • Deleting data from data target
  • v Query performance & Load Performances

Business Content

  • Important of business Content
  • Business Content Installation & Activation
  • Business Content Data Source, DSO\92s, Cubes, Reports, etc\85

Meta Data Repository

  • Important of Metadata Repository

Extraction

  • Flat file & LO Extraction
  • Generic Extraction & Generic Delta
  • FI-SL, Co-PA, DB Connect
  • Business Content Extraction
  • Data Enhancements- Tables, View, Query

Process Chain

  • Types of Process Chains
  • Process Groups & Meta Chain, etc\85

Transport Mechanism

  • Review of system Landscape
  • Collecting Objects
  • Creating Transports
  • Releasing Transport
  • Importing Transport
  • Monitoring Transport

Authorization Concepts

  • Authorization
  • Creating & Assigning Roles

BI 7.0 Reporting

BEx Query Designer

  • Introduction of BEx Query
  • Filters, Columns & Rows
  • Characteristic Restrictions & Free Characteristics
  • Formulas & Calculated Key Figures
  • Restricted Keyfigures & Variables with Texts.

Web Application Designer

  • Creating Web Templates
  • Web Item & properties
  • Drop-down Functions
  • Condition & Integration

Business Explorer Analyzer

  • Introduction to BEx Analyzer
  • Filtering Option
  • Properties Available in Analyzer

Report Designer

  • Creating Reports
  • Formatting columns & Rows
  • Changing font styles with background color
  • Inserting Rows & columns

Integrated Planning

  • Introduction & Planning Application- On web, MS Excel

Types of Projects

  • Real Time Implementation Projects
  • Up-Gradation project
  • Enhancements to the existing Implementation project
  • Support project

Advanced Topics in BI 7.0

  • Analysis process Designer
  • Modeling/Repartitioning
  • Data Mart
  • Open Hub Destination
  • Infoset
  • Multiprovider