SAP BW-BI Online Training
COURSE DURATION : 50 HOURS
BWBI Training course outline.
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
Transportation
Package
Request no
Return codes
Types of Data
Master data
Transaction data
Master Data
Attribute data
Text data
Hierarchy data
Transaction data
Header data
Item data
Scheduline data
Star Scheme Concepts
Classical star schema.(DW)
Extended star schema.(BW)
Modeling & Extraction Objects
Info area
Info objects Catalog
Info objects
Info source
Direct update
Flexible update
Data source
Source system
Application component
Transfer rules
Transfer structure
Communication structure
Info providers
Data targets
Info cubes
Standard Info Cube
Real-Time Info Cube
ODS
DSO
Standard DSO
DSO for Direct Update
Write-optimize DSO
Update rules
Transformations
DTP – Data Transfer Process
Standard DTP
Error DTP
RDA DTP
Direct DTP
Info package
Extract structure
PSA
Standard PSA
Error Stack PSA
Data Acquisition
Standard
Real Time
Re-modeling
Re-partitioning
APD – Analysis Process Design
Visual Composer
IP – Integrated Planning
Data loading using flat files
Attribute data
Text data
Hierarchy data
Transaction data
Live concepts of using MDM
Reusability of master data
Designing the transfer rules, transfer structure and communication according to data using different
techniques Dynamic calculation ,suppressing data adding new functionality to the data of the transfer
rules and update rule level while loading data.
Handling data function while loading data
BW Architecture
PSA Maintenance
Scheduling the data
Data packet by data packet
Complete data scheduling
Scheduling in background
Debugging the Data while loading
Transfer rule level
Update rule level
PSA Processing types
Terminating errors while loading the data
Increasing the data packet size
Application serer file concept _AL11
Scheduling the data in background
Monitoring the data loading
Scheduling the jobs based on periodic values
Canceling and deleting the back ground jobs
ODS
New data table
Active data table
Change log type
ODS SETTING
Automatic
Manual
Details
9 cases of deltas with real scenario
Error handling in deltas
Data Mart
ODS – Info Cube
Info Cube _ Info Cube
ODS –ODS
Multi providers
Info set
Partitioning
Line items dimensions
Performance issues
Roll up
Aggregate
Collapse
Reconstruction
Deletion of data from data Targets
Complete deletion of data
Deleting data by request id
Selective deletions
Process Chain
Direct Schedule
Metachain
Error handling in process chain
Monitoring process chain
Message integration
Success
Error
Always
Scheduling process chain based on Periodic values
Cancelling the process chain jobs
Rescheduling the process chain
Folder creation for a specific process chain
Creating a variant for ABAP programs and integrating in process chain
ALE Remote jobs
Attribute change run
Transportation
Assigning object to the requests
Releasing the Request No and their Dependency
Return code
Mail drafting to basis team regarding transportation
Searching objects locally and business
Contents throughMetaData Repository
Fact less Fact Tables
SQVI-Quick Views
Business content
Definition
Activation
Open hub service
Info spoke
EXTRACTION
Flat files
LOS
LIS
Generic Extraction
Master data
Transaction data
CO-PA
FI-SI
DB connect
Business content extraction
Generic delta
REAL TIME SCENARIO
Product Issues
Ticket Handling
Ticket tool tracker
Error handling
Reporting
BEX Analyzer
BEX Browser
WAD
BEX query designer
Role maintains
Creating a role
Assigning a role
Variables
Types
Represent
Entry
Process
Conditions
Formula
Calculated Key Figures
Restricted key figures
Exceptions
Filters
Free characteristics
Structures
Cell definitions
Query performance
Brain Errors
Forcing variables
Information broadcasting
Cache inactive
Query Monitoring
RRI (report-to-report interface)
Query properties
Debugging reports while Executing
SAP BWBI Online Training by real time industry experts with hands on
Visit : http://www,monstercourses.com more details on BW BI online training
COURSE DURATION : 50 HOURS
BWBI Training course outline.
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
Transportation
Package
Request no
Return codes
Types of Data
Master data
Transaction data
Master Data
Attribute data
Text data
Hierarchy data
Transaction data
Header data
Item data
Scheduline data
Star Scheme Concepts
Classical star schema.(DW)
Extended star schema.(BW)
Modeling & Extraction Objects
Info area
Info objects Catalog
Info objects
Info source
Direct update
Flexible update
Data source
Source system
Application component
Transfer rules
Transfer structure
Communication structure
Info providers
Data targets
Info cubes
Standard Info Cube
Real-Time Info Cube
ODS
DSO
Standard DSO
DSO for Direct Update
Write-optimize DSO
Update rules
Transformations
DTP – Data Transfer Process
Standard DTP
Error DTP
RDA DTP
Direct DTP
Info package
Extract structure
PSA
Standard PSA
Error Stack PSA
Data Acquisition
Standard
Real Time
Re-modeling
Re-partitioning
APD – Analysis Process Design
Visual Composer
IP – Integrated Planning
Data loading using flat files
Attribute data
Text data
Hierarchy data
Transaction data
Live concepts of using MDM
Reusability of master data
Designing the transfer rules, transfer structure and communication according to data using different
techniques Dynamic calculation ,suppressing data adding new functionality to the data of the transfer
rules and update rule level while loading data.
Handling data function while loading data
BW Architecture
PSA Maintenance
Scheduling the data
Data packet by data packet
Complete data scheduling
Scheduling in background
Debugging the Data while loading
Transfer rule level
Update rule level
PSA Processing types
Terminating errors while loading the data
Increasing the data packet size
Application serer file concept _AL11
Scheduling the data in background
Monitoring the data loading
Scheduling the jobs based on periodic values
Canceling and deleting the back ground jobs
ODS
New data table
Active data table
Change log type
ODS SETTING
Automatic
Manual
Details
9 cases of deltas with real scenario
Error handling in deltas
Data Mart
ODS – Info Cube
Info Cube _ Info Cube
ODS –ODS
Multi providers
Info set
Partitioning
Line items dimensions
Performance issues
Roll up
Aggregate
Collapse
Reconstruction
Deletion of data from data Targets
Complete deletion of data
Deleting data by request id
Selective deletions
Process Chain
Direct Schedule
Metachain
Error handling in process chain
Monitoring process chain
Message integration
Success
Error
Always
Scheduling process chain based on Periodic values
Cancelling the process chain jobs
Rescheduling the process chain
Folder creation for a specific process chain
Creating a variant for ABAP programs and integrating in process chain
ALE Remote jobs
Attribute change run
Transportation
Assigning object to the requests
Releasing the Request No and their Dependency
Return code
Mail drafting to basis team regarding transportation
Searching objects locally and business
Contents throughMetaData Repository
Fact less Fact Tables
SQVI-Quick Views
Business content
Definition
Activation
Open hub service
Info spoke
EXTRACTION
Flat files
LOS
LIS
Generic Extraction
Master data
Transaction data
CO-PA
FI-SI
DB connect
Business content extraction
Generic delta
REAL TIME SCENARIO
Product Issues
Ticket Handling
Ticket tool tracker
Error handling
Reporting
BEX Analyzer
BEX Browser
WAD
BEX query designer
Role maintains
Creating a role
Assigning a role
Variables
Types
Represent
Entry
Process
Conditions
Formula
Calculated Key Figures
Restricted key figures
Exceptions
Filters
Free characteristics
Structures
Cell definitions
Query performance
Brain Errors
Forcing variables
Information broadcasting
Cache inactive
Query Monitoring
RRI (report-to-report interface)
Query properties
Debugging reports while Executing
SAP BWBI Online Training by real time industry experts with hands on
Visit : http://www,monstercourses.com more details on BW BI online training
