SAP BW/BI Online Training
Introduction To Data warehouse:
- Data warehousing/ BW/ BI Introduction
- Overview of SAP R/3
- Importance of SAP BI.
- Versions of SAP BI
- Data Ware Housing Concepts
- SAP System Landscape
- OLTP vs. OLAP
- SAP BI Architecture
- Star Schema Concepts – Star Schema Vs Extended Star Schema
- Enterprise Data Warehouse Modeling:
- Objects in SAP BI
- Info Area, Info Object Catalogs
- InfoObjects: Definitions
- - Types: Characteristics, Key Figures, Time, and Unit
- Data Loading Using Flat files - Master Data & Attributes ,Text Data , Hierarchies Data
- Transaction Data
- PSA, Transformation
- Creation of InfoCubes
BI SUITE: Reporting
- Introduction
- BEx Web Application Designer
- BEx Report Designer
- Rows and Columns
- Free Charsterstic & Filters
- How to create Queries.
- How to Restrict Characteristics,
- Formulas
- Exception Cells
- Query Design:
- Defining Exceptions,
- Conditions,
- Restricted Key Figures
- Calculated KeyFigures
- Variables:
- Variable Types(Characteristic Variable, Text Variable , Formula Variable, Hierarchy Variable & Hierarchy Node and its Processing Types,
- Component Properties:
- Properties of Characteristics, Attributes, KeyFigures Properties, Global Query Properties, Copying queries between Cubes, Deleting Query Elements
ETL: Extraction Transforming & Loading
Generic Extraction -
- Table
- View
- Infoset
- Function Module
LO Data Extraction – Customization & Migration Steps
Non - LO Extraction
Update Types : Direct Delta ,Queued Delta Serialized & unsterilized V3 Update
COPA Extraction
FI-GL, AP, AR, & FI-SL Extraction
Data Source Enhancement for LO & Non LO.
Advanced Modelling Topics in SAP BW/BI
InfoCubes: Definitions - Types: Standards, real time, remote Cube
DataStore Objects (DSO): - Types: Standards, Write optimized DSO, Direct update DSO
InfoSets
MultiProviders: Scenarios to create
Infocube VS DSO
Metadata and Doc Management:
- BI Content: Definitions, how to install BI contents
ABAP for SAP BW/BI Consultant
- Field level Routine
- Start Routine
- End Routine
- Expert Routine
- Info package level Routine
Process Chains
- Introduction of Process Chains , Process Types & Groups .
- Meta Chain
- Direct & Background Job scheduling
- Monitoring Process Chains
- Message Integration – Success, Error Message
- Including Delete, create indexes
- Scheduling & Cancelling Process Chains
- Scheduling Process chain in background
- Process Chain Monitoring Techniques How to Schedule Process Chains daily, weekly, monthly
Transport Connection
- System Landscape: - Collecting Objects, Create Transport request, Releasing transport request, Importing Transport request & Error handling, Project Types
Performance Optimization:
Loading Performance
AggregatesCompressionPartitions,Line Item DimensionIndexes
Query Performance
Modeling ConceptsQuery DesignPartitioningCompressionAggregatesQuery Read Mode
Implementation Project
- Project Plan/ Preparation
- Business Blue Print
- Requirement Gathering (URS & FRS )
- Development
- Production
- Technical & Functional Specs
Support Project
- Monitoring Techniques (Daily, weekly & Monthly jobs)
- Handing Tickets
- Various Support Issues & its resolution
- Standard Naming convention in SAP- BI
- OSS Note & Discussion Groups
SAP BW/BI Certification Guidelines
Guiding for SAP BW/BI Certification - Sample questions and documentation for HANA certification provided.Guiding Resume Preparation & Tracking Interviews