SAP BI/BW

 

Module 1-Architecture of SAP

• SAP Landscape
• SAP Sources
• Non SAP source
• Application of SAP
• SAP Landscape SAP (AG)
• SAP BW 7.3
• Query Designing and Reporting
• SAP BOB 14.0
• SAP Hana
• SAP BODS 4.0
• Business objects of SAP LANDSCAPE
• OW BW WORKS?
• SAP BW Works
• SAP BW Works Model description
• PSA data sources
• Info provider
• Transformation & DTP
• Modeling Char & KF

 

Module 2-End to end Data warehousing module and Architecture of SAP-BW

• End to end Data warehousing module
• Modeling
• ETL
• Reporting
• SAP BW TERMS
• SAP easy access
• Data warehousing work bench
• SAP BW Simple Architecture
• Description of architecture

 

Module 3-Sap BW modelling

• Sap BW modelling
• CHAR and KEYE
• Source system
• SAP Source and NON SAP source
• Data source
• PSA
• INfo Providers (Info, cubes, DO, Char)
• Modelling

 

Module 4-Transformation and Scheduler

• How to extract data from Flat File to SAP BW (DS) PSA
• Transformation
• ETL sources
• Internal source
• External source
• Load
• How to change data sources ZDS_EMP (FFSS-ABC)
• How to edit figure salary
• How to edit info object catalog
• Creating a Meta data of target
• How to create an application of company
• How to change Data source ZDC_D (Z file)
• Scheduler (Maintain info Package)

 

Module 5-Data Schema

• SAP BW-Master Data
• SAP BW-Master Data Cable
• SAP BW- Extended star schema
• SAP BW-Master data load
• Attribute of Master Data
• Text of Master data
• Hierarchies of Master data

 

Module 6-SAP BW-Info providers

• Characteristics of info provider
• Overview of data store object (DSO)
• Standard data store object
• Designing a standard DSO
• How to load data in DSO as an info provider
• Edit data store object
• Display data store object
• Display transformation in DSO
• Change transformation in DSO

 

Module 7-Data store object(DSO)-Direct object

• Functionality of DSO
• Advantage of DSO
• Drawback of DSO
• Creation of DSO

 

Module 8-Data store object(DSO)-write optimized

• Write optimized DSO properties
• Creation of write – Optimized DSO
• Write optimized data for fight data

 

Module 9-Infoset

• How to creat infoset
• Do’s and Don’ts for Infoset
• Data Models using for Infoset
• When to use Infoset?
• Join Concepts

 

Module 10-Info cube

• Real time info cube
• Golden rule
• Info cube structure
• Type of info cube
• How to create standard info cube
• Characteristic of info cube
• Key feature
• Info cube additional points
• Info cube design golden rules
• Star schema
• Fact table
• Extended star schema

 

Module 11-Multi provider and Infoset

• Virtual provider and hybrid provider
• Updates rules
• Hybrid provider

 

Module 12-Routines in transformations(Start & end routines)

• Trouble shooting techniques in DTPS
• Business contents (BI)
• Process chain

 

Module 13-What is Extraction in BW

• What is SAP ECC
• Types of SAP Extrace
• Application-Specific
• Cross-Application
• Step To Create Generic Data Source
• Procedure to Extract Data From R3 to BI
• Generic Extraction Process
• BI Side Info Package Creation

 

Module 14-Lo-Cockpit Description

• Lo Data Extraction
• What is event?
• Delta Initialization
• Delta Extraction
• Update Method
• Update Modes
• Setup Table
• LUV
• Delta Queue
• Lo-Cockpit Extraction
• Process of Extraction

 

Module 15-CO-PA Extractor

• How to do CO-PA Extraction

 

Module 16-SAP BW Reporting

• Bex Query Designer
• How to Design a Query in Bex Query Designer
• Bex Query Designer Panel
• Bex Query Designer Standard Tool Bar
• Query Element
• Other Query Element
• Query Properties
• Filter in Query Designer

 

Module 17-Restriction and Exceptions

• Characteristics Restriction
• New Selection
• Restricted Keyfigure
• New formula
• Structure
• Conditions
• Exceptions

 

Module 18 – Project – Bex Analyzer

• Drill down operation
• Apply filter on the table
• Convert the table not the chart format
• Broadcast the workbook
• Reporting etc.