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
9 Reviews
89 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:
Student Feedback
Not Enough Reviews Yet
| Level: | Beginner |
| Duration: | 2.5 hours |
| Type: | Instructor-led |
| Delivery: | Online, instructor-led |
| Release: |
BI 7.x |
| Category: | SAP Business Warehouse |
Share this course with a friend
19
students enrolled.
Join them!
-Geoffrey M.
Related Training
Training 10 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
