SAP BI/BW

 6,500.00

Description

 

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.

Reviews

There are no reviews yet.

Be the first to review “SAP BI/BW”