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

5.0 Average Rating

7 Reviews

72 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

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

Share this course with a friend

8 SAP students

students enrolled.
Join them!

SAP Student testimonial
The final exams were tough but fair and I have already used many of the theories learned in my day to day job.
-Derek  F.
General Ledger Accountant

Related Training

Training 10 or more people?

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

SAP Training for Businesses