SAP BI BW Online Training

SAP BI BW Online Training

Course Content:

Introduction to SAP Business Intelligence:

• SAP Net weaver BI Architecture / BI Platform
• Star Schema and Extended Star Schema
• Multidimensional Modeling
• Entity Relationship Modeling
• Enterprise Data Modeling
• Enterprise Reporting, Query and Analysis
• SAP BW vs Other Data warehousing Tools
• Data Acquisition / Data Extraction concepts

SAP BW Phases:

• Modeling
• Extraction
• Reporting

Modeling:

• Info Area, Info Object Catalogs
• Info Objects (Characteristics & Key Figures)
• Application Component
• Data Source
• Transfer Rules
• Info Source
• Update Rules
• Different types of Routines
• Info Package
• Transformations
• Data Transfer Process (DTP)
• Error DTP
• Metadata Repository

BI 7.0 Info Providers:

• Master Data - Attributes, Texts, Hierarchies
• Standard DSO
• Write-optimized DSO
• Direct Update DSO
• Standard Info Cube
• Virtual Providers
• InfoSet
• MultiProvider
• Aggregation Level
• Others
• Open Hub Destination
• Analysis Process designer

BW 7.3 Info Providers:

• SAP NetWeaver BW 7.3 Features Overview
• Graphical Data Modeling
• Graphical Data Flow Modeling Basics
• Data Flow Copying
• Data Flow Generation
• Data Flow Migration
• Advanced InfoProviders
• Semantically Partitioned Object (SPO)
• Hybrid InfoProviders
• Transient Providers
• The New BW 7.3 Hierarchy ETL

Business Content:

• Importance of Business Content
• Business Content Installation & Activation
• Business Content Data Source, DSO’s, Cubes, Reports, etc…
• Data Acquisition / Data Extraction
• Flat file Extraction
• Business Content Extractions using MD/TD SD,MM and FI
• Logistics Extraction
• Generic Data Extraction using MD/TD Tables
• Delta mechanism
• CO-PA Extraction
• FI-SL Extraction
• Data source Enhancement

Process Chains:

• Process Chains, Process Types
• Scheduling
• Monitor (Header, Status, Details)
• Real time scenarios from support projects

Transport Mechanism:

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

Reporting:

• Introduction of Various Reporting Tools
• Functional Overview of Business Explorer Query Designer
• Introduction of BEx Query
• Reusable Query Elements
• Filters, Columns & Rows
• Characteristic Restrictions & Free Characteristics
• Formulas & Calculated Key Figures
• Restricted Keyfigures and Variables with Texts
• Report to Report Interface or Jump Starts
• Query Extracts using RSCRM_BAPI
• Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer:

• Introduction to BEx Analyzer
• Filtering Option
• Properties available in AnalyzerSAP BW BI Online Training

Performance Improvement:

• Aggregates
• Compression
• Re-Modeling
• Re- Partitioning
• Indexes and DB Statistics
• Number Range Buffering
• Read Mode & OLAP cache
• Line Item Dimension & High Cardinality
• Read Mode & OLAP cache
• Business Warehouse Accelerator
• Others

Types of Projects:

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

Introduction to SAP ABAP:

• What is SAP
• SAP Architecture and where ABAP fits in
• ABAP Development Workbench Tools
• Object Navigator
• Workbench Organizer
• Data Dictionary

ABAP Dictionary:

• Tables
• Views
• Lock Objects

ABAP Programming Techniques:

• Reports Statement
• Line Size
• Line-count
• Message
• Page Heading
• Report Comment Section
• Declarations
• Tables
• Includes
• Variables (Data Types and Data Objects)
• Structures
• Internal Table
• Constants

ABAP for SAP BI Consultant:

• Field level Routine
• Start Routine
• End Routine
• Expert Routine
• Infopackage level Routine
• DataSource Enhancements