| Course Teaching | You are Offering Professional Course | Locality Juinagar |
www.magnifictraining.com - sap bibw Online Training contact us:[email protected] or +919052666559 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa.
sap bibw course content:
SAP-BW
Overview and Concepts
Over view of SAP R/3
Necessity of SAP BW
Versions of SAP BW
Over view of SAP BW
OLAP and OLTP
Data Ware Housing Concepts
Landscape of SAP BW
Homogeneous + Heterogeneous
Integration of BW system with different systems
ERM + MDM + Star Schema
Extended Star Schema
Architecture of SAP BW
Objects in SAP BW
Info Area + Info Objects Catalogs
Characteristics
Key Figures-Cumulative and Non Cumulative
PSA + Transfer Structure/Data Source
Transfer Rules
Info Sources/Communication Structure
ODS + Info Cubes
Types of Info Cubes + Update Rules
Data loading using flat files
Master data + Attributes data
Texts data + Hierarchies’ data
Transactions data + Delta data loading
Data filtration techniques
Transfer rules level
Update rules level
Start routines
SAP BI 7.0
Business Intelligence Concepts and Overview
Modeling: Data warehousing workbench
Components of Data Warehousing workbench
InfoObjects + DataSources
Types of DSOs + DataSources Repository
Migration of 3.*DataSources and recovery of 3.*
dataSources
Differences between ODS(Operational Data Store) and DSO
Data Loading: Master Data
Attributes Data Loading using flat files in BI 7.0
Texts Data Loading using flat files in BI 7.0
Hierarchies Data Loading in 3.*
Concepts on Transformations
Controlling the Data flow with Info Packages
and Data Transfer Process(DTPs)
Data flow concepts in SAP BI 7.0
Transactions Data Loading in BI 7.0
Flat files data loading to Info Cubes
Flat files data loading to DSO
Delta loading to Info Cube Via DSO
DSO
Standard + Direct
Write Optimized
Transformations
Creating Transformations
Types of Transformations
Routines at Transactions
Field Level Routines + Start Routines
End Routines + Expert Routines
BEx Query Desinger
Introduction to BEx Query designer
Filters in the query
Characteristic Restrictions
Rows and Columns
Free Characteristics
Formulas –Calculated KeyFigures
New Selection-Restricted KeyFigures
Structure + Hierarchies
Attributes + Navigational Attributes
Variables + Text Variables
Characteristics Variables
Different Types of Variables
Conditions + Exceptions
Cell Definitions
Report to Report Interface(RRI)
How to use replacement path and customer exit
Variables
Customer exit Programs
Properties of the Components