SAP BIW Course Training


SAP BIW Course Content

  •         BW Versions
  •         Importance of BI
  •         OLAP Vs OLTP
  •         Types of Data
  •         Introduction to SAP R/3 or ECC
  •         Introduction to Data Warehousing
  •         Introduction to SAP BI
  •         Difference between SAP R/3 and SAP BI
  •         Flow diagram for SAP BI
  •         Entity Relationship Model and Multi-dimensional Modelling



BI Modelling

  •         Info Area
  •         Info Object Catalog
  •         Introduction to Info Objects
  •         Types of Info Objects
  •         Characteristic
  •         Attributes
  •         Types of Attributes
  •         KPIs
  •         Time Characteristics
  •         Units
  •         Developing of Info Objects
  •         Creation of Attributes
  •         Making of Info Objects as Targets
  •         Introduction to Business Content
  •         Difference between Info providers and Data Targets
  •         Introduction to Source systems
  •         Types of Source Systems
  •         Introduction to App Comp
  •         Introduction to Data Sources
  •         Types of Data Sources
  •         Creation of Data Sources
  •         Managing of Data Sources

Master Data Loading

Transformation

  •         Field Mapping
  •         Transformation Rules
  •         Field Routine
  •         Start Routine
  •         End Routine
  •         Expert Routine

Info package

  •         Info package Settings
  •         Filters in Info package
  •         Routine in Info package
  •         Info Package Monitoring
  •         Manage of Data Source/PSA
  •         Types of Info packages

DTP

  •         DTP Monitoring
  •         DTP Settings
  •         Routine in DTP
  •         Filters in DTP
  •         Types of DTPs
  •         Error DTP
  •         Debugging of Routines
  •         Semantic Group
  •         Text Data Loading

Data Loading from Work Station

  •         Data Loading from Server
  •         Data Loading using Logical File
  •         Logical File Creation
  •         Loading Data from Different Sources to one Target
  •         Loading Data from one Source to Many Targets
  •         Manage of Master Data
  •         Activation of Master Data

Introduction Transaction Data Targets

Data Store Objects

  •         Types of DSOs
  •         Development of DSO
  •         Settings in DSOs
  •         Data loading to DSOs
  •         Data Activation for DSO
  •         Tables in DSOs
  •         DSO Manage
  •         Administration of DSO
  •         Data mart Status checking
  •         Activation logs checking
  •         Delta process in Std. DSOs
  •         Analysis Process Designer
  •         Loading Data from One Target to another Target
  •         Data deletion from DSO

Introduction to Info Cube

  •         Multi-Dimensional Modelling
  •         Introduction to Ext. Star Schema
  •         Difference between Star and Ext. Star Schema
  •         Different Types of Info cubes
  •         Modelling/Designing of Info cube
  •         Loading data to Info cube
  •         Management of Info cube
  •         Different tables in Info cube
  •         Indexes
  •         Compression
  •         Roll up
  •         Statistics
  •         Aggregates
  •         Partitioning
  •         Loading Performance
  •         DSO to DSO Loading
  •         DSO to Cube loading
  •         Data Acquisition
  •         Data deletion from Info cube
  •         Difference between DSO and Info Cube

Virtual Info providers Multi Providers

Infosets

  •         Different Types Joins in Infoset
  •         Display Data From Infoset
  •         Difference between MP and Infoset

Process Chains

 

  •        Designing of PCs
  •         Types PCs
  •         Managing of PCs
  •         Process Types in PC
  •         Logs in PCs
  •         Monitoring of PCs
  •         Automation of PCs

Open Hub Destination

  •         Open Hub Destination to Work Station(File)
  •         Open Hub Destination to Server(File)
  •         Open Hub Destination using Log File

 

Business Content

  •         Introduction
  •         Installation of BC
  •         Activation BC objects
  •         Enhancement of BC object

Transportation

  •         Introduction to Transport Connection
  •         Collection of objects to Transport
  •         Package Creation
  •         Creation of Transport Request
  •         Existing TR usage
  •         Importing of TR

Data Extraction from R/3 Source

  •         Introduction to Extractions
  •         Business Content Extractors
  •         Installation of BC Data Sources
  •         LO Cockpit
  •         Types of Structures
  •         Delta mechanism & Administration
  •         Setup tables
  •         Deletion and Filling process
  •         Full Loads
  •         Delta Loads
  •         Delta Initialization
  •         Repair Full Load
  •         Update Methods
  •         V3 Job
  •         Generic Extraction
  •         FI-Extraction
  •         CO-PA
  •         MM Extraction
  •         Data Source Enhancement

BEx Reporting

  •         Introduction to Reporting
  •         Components in Reporting tool
  •         Query Analyzer
  •         Filter
  •         Rows
  •         Columns
  •         Free Chars
  •         Selections
  •         Formulas
  •         Restricted KF
  •         Calculated KF
  •         Structures
  •         Conditions
  •         Exceptions
  •         Variables
  •         Types of Variables
  •         Processing Types
  •         Reporting on different Info providers
  •         BEx. Analyzer
  •         RRI
  •         Query Analysis
  •         Query Performance
  •         BEx Broadcaster

Functional Modules Overview

  •         SD Overview
  •         MM Overview
  •         FICO Overview

Project Course Contents

  •       Landscape
  •         Implementation Projects
  •         Support Projects
  •         Issues
  •         Roll out upgrade and migration projects
  •         Documentation
  •         Technical Specifications
  •         Functional Specifications
  •         Ticketing tools
  •         Resume Preparation
  •         Interview Oriented Guidance