SAP BI/BW Online Training Course Content

Duration:3-4 Weeks  

 
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 – 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
 
Bi Concepts & Overview
Modeling: Data warehousing workbench
• Components of data warehousing workbench
• InfoObjects, data source,
• Types of DSO’s , Data Source Repository
• Migration of 3.X data sources & Recovery of 3.X Data sources
• Difference between ODS & DSO
• Data Loading – 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 –Direct DSO –Write Optimized DSO.
 
Types of Info Cubes, Info Sets, MultiProvider
 
• Open Hub & Performance Issue
• Deleting data from data target
• Query performance & Load Performances
 
Business Content
 
• Important of business Content
• Business Content Installation & Activation
• Business Content Data Source, DSO’s, Cubes, Reports, etc…
 
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…
 
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
  1. Send us which course you want to join.
Have a Query?