Learn SAP BEx Analyzer - Training Course
4.6 (187 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,466 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SAP BEx Analyzer - Training Course to your Wishlist.

Add to Wishlist

Learn SAP BEx Analyzer - Training Course

Learn SAP BW BEx Analyzer Reporting with Peter Moxon. In-Depth SAP BI Training Course - Unlimited Access + Updates!
Best Seller
4.6 (187 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,466 students enrolled
Created by Peter Moxon
Last updated 4/2013
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 11 hours on-demand video
  • 2 mins on-demand audio
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the completion of this online training course, you will be able to create and run your own BEx Analyzer reports.
  • You will be able to create BEx Analysis Applications in Microsoft Excel
  • You will be able to customize existing reports and produce reports that can be distributed throughout you organisation.
  • Fully understand how the front end BW Reporting tools work
  • Integrating key figures, characteristics, hierarchies, variables, properties, exceptions and conditions in the query definitions
  • Delivering reports and adhoc-analysis using the BEx Analyzer
  • Configuring report-report interfaces
  • Navigation in SAP BW reports
  • Architecture and functions of the SAP BW analysis tools
View Curriculum
  • User level understanding of how to navigate the SAP GUI or previously completed course: https://www.udemy.com/learn-sap/

You can now join over 400+ students in this SAP BEx Analyzer Video Academy Course.

This in-depth SAP BW BEx training course will teach you how to master the BEx Analyzer and Query Designer tools - the key reporting component of the SAP BW & Business Intelligence suite of applications used by thousands of the worlds largest companies to help them analyze their own business data.

This course is a complete A to Z online learning course for the SAP BEx Analyzer (SAP Business Explorer) and Query Designer. No stone is left un-turned.

The SAP Business Explorer (BEx) offers a high focus on user productivity, with formatted reporting, intuitive ad-hoc analysis, advanced Excel integration, and model-driven BI applications.

This course will teach you how to fully master this toolset. It is fully up-to-date for SAP NetWeaver BW 7.x and provides end users and functional consultants with a detailed reference on how to use all aspects of BEx reporting, from designing queries to linking reports together. You will gain a deep knowledge of BEx and its many uses.

First, learn how to use existing reports already available in your system then create and design flexible query definitions that can be used by a wide variety of users, with a focus on performance and usability. You will delve into the capabilities of BEx Analyzer and enhanced navigation features, such as drag and drop to facilitate end-user interaction, the new design mode to develop reporting applications within MS Excel, and additional integration with Excel formatting and formulas.

You'll quickly master advanced techniques such as using cell definitions, creating Exceptions & Conditions in your queries as well Report-Report-Interfacing (RRI), a tool that enables users to link reports and jump from one report to another containing additional information.

  • BEx Query Designer
  • Accessing InfoProviders
  • Creating Custom Templates
  • Defining Jump Targets
  • Build Analysis Application
  • Integrate Exception & Conditional reporting techniques
  • Embed multiple reports into your Workbooks
  • Learn to build new reports in less than 2 minutes!

A key feature of this course is you will have direct access to Peter Moxon - a seasoned SAP BI consultant to answer any questions.

After you have completed this course you will be able to create unlimited SAP reports, create and use both simple and complex query definitions using the BEx Query Designer and create full Analysis Applications.

Who is the target audience?
  • Financial Accountants
  • Business Reporting specialists
  • Information and Data analysts
  • SAP Power Users
  • SAP Functional Consultants
  • SAP BW Consultants
  • Solution consultants responsible for implementing SAP NetWeaver Business Warehouse
  • Project team members with basic knowledge of Data Warehousing and SAP ERP experience
Compare to Other BEx Analyzer Courses
Curriculum For This Course
59 Lectures
Getting the most out of the SAP BW BEx Analyzer
9 Lectures 01:57:36

Being able to create reports and analyses is an integral part of using a BI solution. This course is all about how we can use the BEx query designer and the BEx Analyzer tools to create queries for reporting and analysis purposes inside SAP BW.

One of the main reasons why companies purchase of Business Intelligence solutions is so that they can have visibility of the data that they collect within their business systems.

Companies realise that they have so much valuable data sat in their business systems that they are losing out by not putting that data to good use.

SAP BW was created to enable companies to get at their data and turn that data into meaningful information to help business decision-makers:

  • analyse how their area of the business is running,
  • identify important trends
  • determine what actions need to be made in the future to help keep their company moving in the right direction.

First Steps

The first thing we’re going to do in this course is use the BEx Analyzer to run queries and perform ad-hoc analysis using the Microsoft Excel application. SAP developed the BEx Analyzer to work as a plug-in with Microsoft Excel because Excel is the most popular analysis tool used by businesses today and it makes perfect sense to use an application that has so many functions and people are comfortable using.

SAP also created a web version of the BEx Analyzer and this is called the BEx Web Analyzer but, we’re not going to cover that in this course. It does function in a very similar way and the majority of the information that we will cover in this course will also apply to creating BEx web queries.

So without further ado let’s get cracking. We will take a look at how we can analyse data using the BEx Analyzer and the procedures used to build your own analysis application within Excel.

Preview 02:23

This lesson will show you how to launch the BEx Analyzer
Preview 02:34

Here we look at how to find and run queries. We look at History, Favourites, InfoProviders & Roles
Preview 10:46

Test your knowledge on how to open existing BEx reports

How to open reports
1 question

In this video, we will focus on the Default Output that we see on the screen and we will look at some of the features that are presented to us immediately the query runs.

The BEx Analyzer Default Query Output

Here we will go through the detailed functions made available through the SAP BEx Analyzer toolbar.

The Functions of the BEx Analyzer Toolbar

In this lesson we will start using some of the powerful Data Analysis tools within the BExAnalyzer. Specifically, we're going to focus on Filters and Navigation options.
BEx Analyzer Data Analysis Functions - Part 1 - Filters and Navigation options

In this video we will continue going through Navigation and Filter options in BEx reports.
BEx Analyzer Data Analysis Functions - Part 2 - More Filters

We will continue with a focus on Filtering and Navigating the data in our report but here we will dive into Characteristic & Query Properties
BEx Analyzer Data Analysis Functions - Part 3 Characteristic & Query Properties

Here we will go through the steps for saving queries and query views within Workbooks and saving query view independently. 
Saving BEx Workbooks and Query Views
Creating Queries using the SAP BEx Query Designer
7 Lectures 01:07:16

In this lesson we look at the architecture that makes up the SAP BW BW reporting landscape.

Overview of the SAP BW Reporting tools landscape

This lesson shows how to get started with the BEx Query Designer.
Starting the BEx Query Designer And Screen Layout

This lesson gives us a run through of the different Query Designer toolbars and menu options.
BEx Query Designer Menus and Toolbar

Here we start to create a very first BEx query.
Creating our first BEx query

We will now build on the query we have created by adding more Characteristics and Key Figures
Enhance our first BEx query

The lesson will introduce filters to our query design.
Defining filters for our BEx query

Lets focus on the query design with regards to formatting the output a little better by using hierarchy navigation views
Compress and Expand Key Figures and Hierarchies
Building Dynamic Selections into BEx Queries
10 Lectures 01:41:27
This lesson will introduce Dynamic filters options we have to allow the report user to filter the reported data prior to seeing the query output.
Dynamic Filters

This lesson will cover OLAP variables.
OLAP Variables

We can use hierarchies variables for data selection too. This allows the user to make large complicated data selections with ease. First though, you need to make sure you select the correct version of your hierarchy that you want to filter on.
This lesson shows you how.
Hierarchy Variables

Making use of Hierarchy Node variables allow the user to make those fast hierarchy selections. 
Hierarchy Node Variables

Replacement Path variables are awesome! They allow you to add what seems like complicated data selections and field naming to your reports. The truth is.... it's as easy as any other type of dynamic variable..... EASY
Replacement path variables

This lesson will show you how to use the replacement path processing types to create dynamic text elements (field names, query names etc...) in your queries.
Text Variables

Formula variables are similar to text variables to allow you to create Calculated Key Figures, exceptions and conditions.
Formula Variables

Adding the relevant data security to your queries is easy when Authorisation variables are used. This lesson gives an overview.
Authorisation Variables

This lesson shows you how to use the SAP designed variables in your queries.
SAP Exit Variables

Like SAP Exits, Customer Exits can also be used in your queries. This lessons covers how to use them and how they are created.
Customer Exit Variables
Structuring our queries for re-use
3 Lectures 29:34
Structures allow us to group elements of our query together. This lesson covers their use and how we can reuse them in other queries.

Now we are using 2 structures in our queries we can then make use of Cell Definitions. This lesson shows you how.
Cell Definitions

Here we go into a more detailed discussion on reusing and managing structures.
Reusing Structures
Selections and Formulas
3 Lectures 35:46
We have already looked at selections and formulas in various videos, but we haven't discussed them in detail. This lesson discusses Local query objects verses Global query objects along with RKF's & CKF's.
Selections and Formulas Overview

This lesson with focus on Selections in Key Figures and how we create Restricted Key Figures.

This lesson will show you how to create new Key Figures using Formulas
Reusable Key Figures and Characteristics
2 Lectures 12:23
Now you know how to create restrictions on our key figures, lets see how we can create Restricted Key Figures (RKF's)
Restricted Key Figures

Now you know how to create formulas, lets see how we can create Calculated Key Figures (CKF's)
Calculated Key Figures
Properties of BEx Query Objects
3 Lectures 52:00
This lesson will focus on the specific Characteristic properties you can set in your queries.
Characteristic Query Element Properties

This lesson will focus on the specific Key Figure properties you can set in your queries.
Key Figure Query Element Properties

This lesson will focus on the Query properties as a whole.
Query Element Properties
Advanced Query Options for Analyzing Data
3 Lectures 01:25:54
Conditions add an extra filter element to your queries. This lesson shows you how to create them.
Creating Conditions

Exceptions allow you to highlight data in your query according to rules you define in the query designer. This lesson shows you how to create them.
Creating Exceptions

Report to Report Interfaces (RRI's) allow you to link queries together. Not only that, you can also get them to work together to pas filter data from one query to the next. This lesson shows you how.
Report to Report Interfaces (RRI)
SAP BW BEx Analysis Applications
13 Lectures 02:05:51
Time to switch back to the BEx Analyzer and see how we can start to build Analysis Applications.
BEx Analysis Applications Introduction

This lesson takes you through all the configuration options the Analysis Grid gives you in your Analysis Applications. 
Design Mode and the Analysis Grid

In this lesson you will learn how to configure and make use of the Navigation Pane - Part of the BEx design toolbar.
Navigation Pane

Here, we go through the option offered through the Filter design item.
List of Filters

Adding Buttons to you application can give your unlimited options. See how they can be setup and configured.
Add interactive Buttons

This video will show you how to configure Drop-Down boxes and attach them to your characteristics.
Drop-Down Boxes

This video will show you how to configure Check-Box Groups and attach them to your characteristics.
Check-Box Groups

This video will show you how to configure Radio Button Groups and attach them to your characteristics.
Radio Button Groups

Here you get to see how to add the options to enable and disable your query Conditions at report runtime.
Adding Conditions

Here you get to see how to add the options to enable and disable your query Exceptions at report runtime.

Add Exceptions

This lesson shows how to add Text Elements onto your analysis application.

Text Elements

Here you get to see how to add system messages to your reports.
BEx Messages

Here we go through the various settings you can configure to your BEx WorkBooks.
Workbook Settings
Final Project - Build a BEx Analysis Application
5 Lectures 42:21

You have made it all the way through the course. This sections of videos takes you through an example project where we create a SAP BEx Analysis Application from scratch.

Lets get started!

Part 1 - Introduction and Manager Report Setup

Here we setup the Employee report keeping in mind our application goal.
Part 2 - Employee Report Setup

Here we pull together both reports so we can use 1 drop-down box to filter both queries at once.
Part 3 - Multi Report Filtering with DropDown Boxes

In this video we continue building the application and add an button to remove all filter values from our query.
Part 4 - Add a Button, Refine and Position Elements of our BEx Reports

In this lesson we wrap things up by adding a chart to our application and reconfigure the button. 
Part 5 - Adding Dynamic Charts
1 More Section
About the Instructor
Peter Moxon
4.3 Average rating
3,581 Reviews
21,134 Students
7 Courses
Head Trainer at Sap Training HQ

SAP consultant and the #1 SAP instructor on Udemy.

I hope you find my courses interesting and I really hope you enjoy them.