SAP BI Training

Duration: approximately 40 – 45hrs.
1. SAP Introduction:
 ERP Introduction
 Data Ware Housing Concepts
 Over View Concepts of BW
 Over view of SAP R/3 Types of Applications
 OLTP
 OLAP
 R/3 Architectures
 Landscape of SAP
 Business Intelligence
2. MODELLING:
 Difference between BW&BI
 Info object types:
 Star schema & Extended star schema
 Master Data
 Transaction data
 Modeling & Extraction Objects
 Info area
 Info objects Catalog
 Info objects
 Data source
 Source system
 Application component
 Data loading using flat files
 Attribute data
 Text data
 Hierarchy data
 Transaction data
 Type of data sources:
 Master data
 Text data
 Transaction data
 Hierarchy
 Info package
 PSA
 DTP
 Infoproviders
 Types of Infoproviders
 Multiprovider
 Infoset
 Info cube
 Infoobject
 DSO
Page 2 of 3
 DSO (Data Store Object)
 Types of DSO’s
 Standard dso
 Direct update DSO
 Write optimize DSO
 2. DSO Tables:
 1.Active data table
 2.New data table
 3.Change log table
 Performance Tuning
 Loading performance
 Adjusting Data packet size
 ABAP code optimization
 Delete indexes
 Delete application logs
 Loading master data before loading transaction data
 Query performance
 cube partition
 create indexes
 aggregates
 compression
 Multiprovider
 Line item dimension
 High cardinality
 BI Accelerator
 Infocube
 Types of Infocubes
 Types of DTPS
 Re-modeling
 Re-partition
 Business content
 Transportation
 Open hub destination
 Routines
 Start
 Field
 End
 Expert
 Process chains
3. REPORTING:
 BEX TOOL INTRODUCTION
 Query Designer
 Analyzer
 WAD (Web Application Designer)
 Report designer
Page 3 of 3
 Restricted Key Figures
 Calculated Key Figures
 Free characteristics
 Filters
 Local & Global structures
 Query properties
 Exceptions
 Conditions
 Variables:
 Char
 Text
 Formula
 Hierarchy
 Hierarchy node
 Processing Types:
 User entry/Manual entry
 Replacement path
 Customer Exit
 Sap Exit
 Authorization
 RRI
 Currency & Unit conversions
 Types of attributes
 Work Books
 Information Broadcasting
4. EXTRACTION:
 Different source systems
 R/3 (ECC 6.0) Introduction
 Categorization of data sources
 Replication of Data sources
 Standard data source enhancement
 Generic (Custom) data sources & different delta types
 Table
 View
 Function module
 Logistics Extraction
 COPA Extraction
 Logistics Extraction
 Generic Extraction
 Delta Mechanism
5. REAL TIME SCENARIO’s
 BI Interview Questions
 BI Real time Scenarios
 Miscellaneous Topics

Share
Share
Share
Social Media Auto Publish Powered By : XYZScripts.com