SAP Business Warehouse Query Design and Analysis

////SAP Business Warehouse Query Design and Analysis

SAP Business Warehouse Query Design and Analysis

Course ID: BW305 5 Days

SAP Business Warehouse Query Design and Analysis


This course gives you the knolwedge to create query definitions using the Bex Query and to make them available for OLAP Analysis



  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • User




Instructor-led / Virtual Instructor-led

  • Singapore: Upon Request



  • Basic knowledge of data warehousing


  • Experience and sound knowledge of the subject matter in at least one SAP
  • ERP application course


This course will prepare you to:

  • Learn how to create queries in BEx Query Designer
  • Learn how to use advanced query functions
  • Learn how to perform OLAP Analysis


Module 1: Data Warehousing

  • Describing Data Warehousing
  • Describing Data Warehouse Architecture
  • Using Reporting Tools

Module 2: Navigation Options in Reports

  • Using the Navigation Options in Reports
  • Saving Analysis Views and Workbooks

Module 3: Simple Queries

  • Creating Simple Queries
  • Finding a Query
  • Filtering Query Definition Data
  • Configuring Query Properties

Module 4: 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

Module 5: Queries with Multiple Structures

  • Creating Structures
  • Resolving Formula Collision
  • Designing Detailed Queries with the Cell Editor

Module 6: 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

Module 7: 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

Module 8: Exceptions and Conditions in Queries

  • Creating Exceptions in Query Design
  • Creating Conditions in Query Design

Module 9: Report-Report Interface

  • Using the Report-Report Interface

Module 10: Query Performance Optimization

  • Optimizing Query Performance
  • Configuring Query Read Mode
  • Using Performance Monitoring Tools

Module 11: Queries Management and Authorizations Overview

  • Managing Query Objects
  • Describing Authorizations

Module 12: Reporting Options

  • Outlining Reporting Options for SAP BW

What’s Next

Subscribe to our mailing list for special offers and promotions.

Thank you! Your subscription has been confirmed. You'll hear from us soon.