SAP BI BW Quality Course Materials

SAP BI BW Quality Course Materials

Course Content:

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 Extract

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.