SAP BW

SAP BI/BW Training Course Content : -

§  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

§  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

Extraction and Reporting

§  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.

§  Slowly changing dimensions and realignments

§  Universal Data Connect (UDC )

§  BW and XI integration

§  BW and APO integration