SAP Training: SAP BEx Query Designer and Analyzer

SAP BEx Query Designer and Analyzer

Learn how to create BEx Queries! You will learn how to create front-end reports in the SAP BEx Query Designer and run those queries within SAP Business Explorer Analyzer discovering meaningful insights about your data residing in BI/BW. End the course with practice exercises to review your knowledge.

In this course you will learn:

Not Enough Reviews Yet

Course Goal

  • Learn how to create BEx Queries
  • Understand the difference between Query Designer and Query Analyzer
  • Create and Execute queries based on your SAP BI/BW Data


  • Consultants
  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members

Lesson Plan

Lesson Description Preview
Section 1: Introduction to BEx Analyzer
1 Launching BEx and Opening Queries Preview
2 BEx Query Navigation, Button Layout, and Filtering
3 Editing a BEx query on the fly and BEx Analyzer Toolbar Options
4 BEx Analyzer Report Output Properties
Section 2: BEx Query Designer
5 Query Designer Report Properties
6 Quickly adding a local formula to report output
7 Query Designer Overview
8 Static Characteristic Restrictions
9 Filtering with dynamic variables
10 Selection Option Variable Filter
11 Using Multiple Selection Option Variable Filters
12 Dynamic Text Variables
13 Calculated Key Figures
14 Structures - Characteristic and Key Figure
15 Key Figure Hierarchies
16 Conditions
17 Exceptions
Section 3: BEx Analyzer and Query Designer Exercises
18 Query Designer - BEx Analyzer Filter
19 BEx Analyzer - Creating and Opening Views
20 BEx Query Designer - Creating Filters
21 Query Designer - Workbooks - Copy Sheet and Filtering
22 Local Formulas at the BEx Analyzer Level
23 Restricted Key Figures


Robert Davis

4.8 Average Rating

10 Reviews

96 Students

3 Courses

BI Consultant

Glastonbury, Connecticut, USA

Business Intelligence consultant with over ten years of experience in government, insurance, manufacturing, healthcare, utilities, higher ed, and other industries. I was trained by the best analytics mentors at Accenture and today I leverage SAP BI/BW/BO drive business strategy, revamp customer experience and revolutionize existing operational processes. 


More Courses by Robert Davis:
SAP BI/BW 7.4 Training


Business Objects Web Intelligence 4.x Training


Student Feedback

Not Enough Reviews Yet

Language: English
Level: Beginner
Duration: 2.5 hours
Type:  Instructor-led
Delivery: Online, instructor-led
Release: BI 7.x
Category: SAP Business Warehouse

Share this course with a friend

SAP students


student views.
Join them!

SAP Student testimonial
Fantastic! I will take another course with MMC. Your services were easy to use. The support via live chat was super & immediate.
-Pamela  G.
Sr. International Sales Development Rep
Chemical Abstracts Service

Related Training

Training 10 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses