SAP BW 7.4 Online Training

SAP BW 7.4 Online Training Course Content

• Data Warehouse Introduction
• BW / BI Introduction
• SAP Landscape
• DSS
• Standard Naming convention in SAP- BI
• Discussion Groups

• OLTP Vs OLAP
• ETL
• Star Schema
• Snow Flake Schema
• Business Warehouse Architecture
• Extended Star Schema
• DIM / SID Tables
• Data Storage
• Data Acquisition
• Reporting and Analysis Tools

• InfoArea ,Info Object ,InfoObject Catalog
• Info Object Definitions : Characteristics , Key Figures, Time and Unit
• Dimension / Key Figures
• Basic Cube / Transactional Cube
• Virtual/Remote Cube
• Multi-Provider
• ODS / Data Store Object ( DSO )
• PSA
• Aggregates
• InfoSets
• Compression
• Indexes and Partition

• Business Content, How to install BI contents.

• R/3 Data ETL Process
• Flat File ETL Process
• Monitor
• Source System
• Master Data ( Attributes , Texts and Hierarchies )
• Extract Structure – DataSource/Transfer Structure
• Communication Structure
• Transfer / Update Rules / Transformations
• Info Package
• R3 / Flat File Data
• Delta Extraction
• Standard BC
• Custom Table Extraction
• Creation of Data Transfer Process ( DTP )
• Info Package
• Process Chain

• Queries, Tabular Queries
• Query Properties
• Variables: variable wizard , variable types and processing types.
• Restricted Key Figures
• Calculated Key Figures
• Structures: creating re-usable structures
• Cell Definition
• Conditions and Exceptions
• Query Copy/Delete between cubes.
• Workbook
• Queries
• Personalize Variables
• Data Area and Query Area
• Web Template iView Creation
• Publish Web Template in the portal