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