BI/BW

SAP BI And SAP BW Online Training Course Details…

What is the difference between BI and BW

BW refers to SAP BW which is SAP Data Warehouse. Up to version 3.5, BW is being called by the name SAP BW. From version 7.0 onwards, the name has been changed to SAP BI. BI refers not just Data Warehouse, but a complete set of products provided by SAP to build a Business Intelligence system.

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
• Multi provider