BW/BI

SAP BW/BI Training 

Course Description:

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

Comments are closed