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:

New Course - 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

100 Students

3 Courses

Top Rated Courses

BI Consultant

Glastonbury, Connecticut, USA

I am a Business Intelligence consultant with over 12 years experience delivering BI and IT projects using a consultative, collaborative approach in roles spanning Solution Principal, Engagement Lead, Architect and Developer; comprehensive knowledge and experience in data visualization, BI tool training, Agile methodology, BI data discovery and visual analytics best practices; strong technologist working with cutting edge tools and technologies. 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


Annual Subscription to All Courses


Or subscribe to this individual course for

Student Feedback

New Course - Not Enough Reviews Yet

Annual Subscription to All Courses


Or subscribe to this individual course for

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
Your courses are excellent which is why I continue to purchase from you.
-Graham  A.
SAP SD/OTC Senior Associate

Training 5 or more people?

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

SAP Training for Businesses