Sap Bi bw Abap Training
Sap Bi bw Abap Training
- Data warehouse fundamentals
- Introduction to SAP R/3, ECC and BW
- BW architecture
- Multi dimensional Modeling
- Star Schema, BW extended Star Schema
- Administrator Work Bench
- Info Objects ( attributes and texts and hierarchies)
- Info Cubes, Transactional ( Real-time ) Info Cubes
- ODS ( DSO) -> Standard, Transactional and Write Optimized
- PSA, Source Systems
- Info Source
- Info Package
- Transfer Rules
- Update Rules
- Transformation
- Data Transfer Process
- Loading Master Data using flat files
- ABAP Routines
- Start, End Routine, Expert Routines, Field Routines.
- Loading transaction data using flat files
- ODS -> Change Log, Active Table and New Table
- Managing Delta using ODS
- Multi Providers
- Process Chains
- Open Hub service
- Data Marts
- Info Spokes
- Open Hub Destination
- Aggregates
- Activating the Business content
- Loading Master data from ECC
- Delta Management
- Various types of R3 Extractors
- Extraction from LO Cockpit
- User Exits
- SAP Landscape and Transports
- Real Time Data Acquisition
- BEx reporting -> BEx Query Designer, Calculated and Restricted Key
- Figures, Variables ( Characteristic, Formula and Text Variables )
- Query properties, Exceptions and Conditions, BEx Analyzer
- Workbooks, Report to Report Interface (RRI )
- Information Broadcasting
- Web Application Designer
- Report Designer
- Generic Extractors
- InfoSets
- Slowly changing dimensions and realignments
- Universal Data Connect (UDC )
- BW and XI integration
- BW and APO integration
Extraction
- LO Extraction and Non LO Extraction
- Generic Extraction based on Query, Infoset view, Function Module
- ABAP Customer exits, SAP Exits and User exits.
- ABAP Istep0, istep1, istep2 Variables creation.