• No products in the cart.

BEx
4.5

98

ratings 

Learn how to create BEx Queries! In this course you'll learn how to create front end reports in BEx Query Designer and execute those queries with BEx Analyzer to uncover insights about your data

$399.00
Course Access

Unlimited Duration

Last Updated

July 29, 2021

Students Enrolled

999

Total Video Time

2 hours, 45 minutes

Posted by
Certification

Course Description

This is a truly a step-by-step course that will take you into the incredible world of BEx Query Design and Analysis. Watch just a few of our training videos and you will immediately understand how both BEx Analyzer and Query Designer work!   Learn by doing! Each section builds on the others to keep you both challenged and engaged.After our introductory section, every module is independent so you can start from wherever you'd like. The more you learn and practice these skills, the better you will get. Feel free to take your time while you master this valuable set of Query Design skills.   This class will make you a highly proficient BEx Query Designer. By the end of this course you will confidently add BEx Query Design to your CV.  

What are the requirements?

Basic knowledge of SAP

What am I going to get from this course?

  • Over 28 Lectures and 4 hours of content!
  • Introduction to SAP BEx Analyzer
  • Starting BEx Analyzer from within SAP BW
  • Starting BEx Analyzer via the front end GUI
  • Opening Queries
  • Find, InfoProvider Selection, Roles, History
  • BEx Analyzer Output Options
  • Report-Level Filter Types
  • Charts, Information
  • Create local Calculations and Formulas
  • Editing queries on the fly
  • BEx Analyzer Toolbar Options
  • Opening, Saving, Save As (workbook, view), Refresh
  • Creating and Opening Views
  • Change Variables and more
  • Create New Query (launches Query Designer)
  • BEx Broadcaster, Report Designer, Web Analyzer
  • Copy Sheet, System Info, Global Settings
  • Introduction to SAP BEx Query Designer
  • Starting BEx Query Designer from within SAP BW
  • Starting BEx Query Designer via the front end GUI
  • Creating a new Query
  • BEx Query Designer Panes
  • InfoProvider, Filter, Rows/Columns, Structures
  • Properties, Tasks, Messages
  • BEx Query Designer Menu Overview
  • Create/Choose a query to edit
  • BEx Report Design Options
  • Using Filters (static vs dynamic)
  • Conditions (TOP N)
  • Exceptions (Conditional formatting)
  • Variables
  • Selection Option
  • Multi-Select Option
  • Hierarchies
  • Calculated & Restricted Key Figures

What is the target audience?

  • You should take this course if want to learn BEx Query Design and Analysis completely from scratch
  • You should take this course if you know some BEx Query Design and Analysis skills but want to get better
  • You should take this course if you are good in SAP BI/BW and want to take your skills to the next level and truly leverage the full potential of BI/BW by learning how to report on data stored in the BW database
Profile Photo
Rob Davis
4.58 4.575
6388

Studens

About Instructor

More Courses by Insturctor

Course Curriculum

    • 1.1.1 – Launching BEx and Opening Queries 00:12:00
    • 1.1.2 – BEx Query Navigation, Button Layout, and Filtering 00:13:00
    • 1.1.3 – Editing a BEx query on the fly and BEx Analyzer Toolbar Options 00:11:00
    • 1.1.4 – BEx Analyzer Report Output Properties 00:05:00
    • 1.1.5 – Query Designer Report Properties 00:05:00
    • 1.1.6 – Quickly adding a local formula to report output 00:03:00
    • 1.1.7 – Query Designer Overview 00:17:00
    • 1.1.8 – Static Characteristic Restrictions 00:10:00
    • 1.1.9 – Filtering with Dynamic Variables 00:08:00
    • 1.1.10 – Selection Option Variable Filter 00:06:00
    • 1.1.11 – Using Multiple Selection Option Variable Filters 00:05:00
    • 1.1.12 – Dynamic Text Variables 00:07:00
    • 1.1.13 – Calculated Key Figures 00:06:00
    • 1.1.14 – Structures – Characteristic and Key Figure 00:08:00
    • 1.1.15 – Key Figure Hierarchies 00:04:00
    • 1.1.16 – Conditions 00:05:00
    • 1.1.17 – Exceptions 00:08:00
    • 1.2.1 – Query Designer – BEx Analyzer Filter 00:04:00
    • 1.2.2 – BEx Analyzer – Creating and Opening Views 00:04:00
    • 1.2.3 – BEx Query Designer – Creating Filters 00:05:00
    • 1.2.4 – Query Designer – Workbooks – Copy Sheet and Filtering 00:10:00
    • 1.2.5 – Local Formulas at the BEx Analyzer Level 00:05:00
    • 1.2.6 – Restricted Key Figures 00:04:00
    • 1.3.1 – BEx Certification Prep Documents 00:00:00

Course Reviews

Business Intelligence Solutions