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

5.0 Average Rating

7 Reviews

65 Students

3 Courses

Robert Davis

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: