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.
New Course - 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
Exam/Certificate
- Certificate of Completion (more certification info)
Lesson Plan
| # | Description | |
|---|---|---|
| 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
4.8 Average Rating
12 Reviews
103 Students
3 Courses
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:
This step-by-step course will take you into the incredible world of SAP BI/BW. The extensive overview section is valu...
Do you need more from SAP reporting than canned reports? Take a knowledege dive into Business Objects with a deep foc...
Student Feedback
New Course - Not Enough Reviews Yet
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 |
