Home > Vendors > sap > bw305

BW305 - SAP Business Warehouse Query Design and Analysis


Duration: 5 days

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


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



  • Basic knowledge of data warehousing


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


This course is not associated with any Certification.


Show Schedule for:

Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy