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.

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

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

12 Reviews

103 Students

3 Courses

Robert Davis

BI Consultant

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
SAP BI/BW 7.4 Training

This step-by-step course will take you into the incredible world of SAP BI/BW. The extensive overview section is valu...


Average Rating

Business Objects Web Intelligence 4.x Training
Business Objects Web Intelligence 4.x Training

Do you need more from SAP reporting than canned reports? Take a knowledege dive into Business Objects with a deep foc...


Average Rating

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

Annual Subscription to All Courses

Or subscribe to this course for


Training 5 or more people?

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

SAP Training for Businesses

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

SAP students


student views.
Join them!

Related Courses