Course Code	Description
BW305	SAP Business Warehouse Query Design and Analysis
BW310	BW - Enterprise Data Warehousing
BW370	BW - Integrated Planning

• BW305 - SAP Business Warehouse Query Design and Analysis

  • Data Warehousing
    • Describing Data Warehousing
    • Describing Data Warehouse Architecture
    • Using Reporting Tools
  • Navigation Options in Reports
    • Using the Navigation Options in Reports
    • Saving Analysis Views and Workbooks
  • Simple Queries
    • Creating Simple Queries
    • Finding a Query
    • Filtering Query Definition Data
    • Configuring Query Properties
  • Key Figures and Structures in Queries
    • Creating Restricted Key Figures
    • Creating Calculated Key Figures
    • Creating a New Formula with Boolean Operators
    • Configuring Properties of Key Figures
    • Using Exception and Nested Exception Aggregation
  • Queries with Multiple Structures
    • Creating Structures
    • Resolving Formula Collision
    • Designing Detailed Queries with the Cell Editor
  • Characteristics and Hierarchies in Queries
    • Configuring the Properties of Characteristics
    • Running Display and Navigation Attribute Queries
    • Adding Hierarchies to Reports
    • Using Hierarchies and Structures
    • Adding External Hierarchies to a Report
    • Creating External Hierarchies
  • Variables in Queries
    • Using Variables
    • Creating Characteristic Value and Text Variables in Queries
    • Creating Hierarchy and Hierarchy Node Variables in Queries
    • Creating Formula Variables in Queries
    • Activating Business Content Variables
  • Exceptions and Conditions in Queries
    • Creating Exceptions in Query Design
    • Creating Conditions in Query Design
  • Report-Report Interface
    • Using the Report-Report Interface
  • Query Performance Optimization
    • Optimizing Query Performance
    • Configuring Query Read Mode
    • Using Performance Monitoring Tools
  • Queries Management and Authorizations Overview
    • Managing Query Objects
    • Describing Authorizations
  • Reporting Options
    • Outlining Reporting Options for SAP BW

• BW310 - BW - Enterprise Data Warehousing

  • Data Warehousing
    • Describing Data Warehouse Systems
    • Describing Data Warehouse Architecture
    • Using the Data Warehousing Workbench
  • Master Data Modeling in SAP BW
    • Describing InfoObjects
    • Creating Characteristic InfoObjects
  • The Loading of Master Data from SAP Data Sources
    • Describing Data Flow
    • Modeling a Master Data Flow
    • Loading a Master Data Flow
    • Modeling with the Graphical Data Flow Tool
  • Loading of Transaction Data from SAP DataSources
    • Describing the Core InfoProviders
    • Creating a Key Figure InfoObject
    • Creating a DataStore Object (DSO)
    • Loading Transaction Data into a Data Store Object
    • Describing the Extended Star Schema of an InfoCube
    • Creating InfoCubes
    • Loading Transaction Data into an InfoCube
  • Master Data Loading from Flat File Data Sources
    • Loading Data From a Flat File
    • Describing the Data Flow in Detail
    • Describing the Data Loading Process in Detail
  • InfoProviders in SAP BW
    • Explaining the InfoProviders Used in SAP BW – Introduction
    • Creating MultiProviders
  • Usage of SAP BI Content
    • Using BI Content
  • Query Performance Optimization
    • Optimizing Query Performance
    • Monitoring Performance
    • Creating and Filling Aggregates
  • The SAP BW Administration
    • Describing Administrative Tasks and Tools
    • Administrating the InfoCubes
    • Administrating the DataStore Objects
    • Creating Process Chains

• BW370 - BW - Integrated Planning

  • Defining BW-IP and PAK
  • Setting up planning structures with the ABAP Planning Modeler
  • Modelling, setting up and Testing planning functions via Planning Sequences
  • Configuring input ready queries with the BEx Query Designer
  • Adding comments to planning queries
  • Explaining Locking of Transaction Data
  • Creating an Analysis Office Workbook for Planning
  • Creating a Design Studio Web Application for Planning
  • Working with Characteristic Relationship
  • Using Aggregation and Disaggregation in Planning Scenarios
  • Setting up Advanced Planning Functions like FOX, ABAP and SQL- Script
  • Introducing Inverse Formulas