SAP Training: SAP BEx Query Designer and Analyzer

IC0671

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

Audience

  • 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



Instructor

Robert Davis

4.9 Average Rating

9 Reviews

81 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

  (4.8)

Business Objects Web Intelligence 4.x Training

  (5.0)



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



14 SAP students

students enrolled.
Join them!


SAP Student testimonial
I have been looking for the right SAP training for a long time. With MMC, I have learned the core & essentials of SAP knowledge that I need.
-Joel  M.
IT Manager
JFC North America


Related Training


Training 10 or more people?

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

SAP Training for Businesses