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.

2  Reviews   5.0 of 5.0

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

Exam/Certificate


Lesson Plan

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

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

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

14 Reviews

114 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...

4.7

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...

5.0

Average Rating

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$139


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

177

student views.
Join them!


Related Courses