Course announcements

  • This course is also available in a self-paced e-learning format with an active subscription to the SAP Learning Hub, as BW305E.
  • This course gives you the knolwedge to create query definitions using the Bex Query and to make them available for OLAP Analysis

Course information

  • 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
  • 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
  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Program / Project Manager
  • User


  • Basic knowledge of data warehousing


  • Experience and sound knowledge of the subject matter in at least one SAP
  • ERP application course
  • SAP Business Warehouse 7.4
  • This course focuses on BEx query design. SAP BusinessObjects Analysis is the tool that is used for query execution.
  • Course material available as flipbook in LH

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more

This course is also available as a test system within SAP Live Access

Learn more