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.

3  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
12:21 mins
3
Editing a BEx query on the fly and BEx Analyzer Toolbar Options
10:19 mins
4
BEx Analyzer Report Output Properties
04:46 mins

5
Query Designer Report Properties
04:23 mins
6
Quickly adding a local formula to report output
02:07 mins
7
Query Designer Overview
16:54 mins
8
Static Characteristic Restrictions
09:32 mins
9
Filtering with dynamic variables
07:10 mins
10
Selection Option Variable Filter
05:53 mins
11
Using Multiple Selection Option Variable Filters
04:08 mins
12
Dynamic Text Variables
07:07 mins
13
Calculated Key Figures
06:08 mins
14
Structures - Characteristic and Key Figure
07:40 mins
15
Key Figure Hierarchies
04:01 mins
16
Conditions
04:38 mins
17
Exceptions
07:49 mins

18
Query Designer - BEx Analyzer Filter
03:52 mins
19
BEx Analyzer - Creating and Opening Views
03:25 mins
20
BEx Query Designer - Creating Filters
04:04 mins
21
Query Designer - Workbooks - Copy Sheet and Filtering
09:04 mins
22
Local Formulas at the BEx Analyzer Level
04:38 mins
23
Restricted Key Figures
02:07 mins

Instructor

Robert Davis

4.9 Average Rating

17 Reviews

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

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

Subscribe to All Courses
Subscribe

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

209

student views.
Join them!


Related Courses