Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Learn SAP BEx Analyzer - Training Course

Learn SAP BW BEx Analyzer Reporting with Peter Moxon. In-Depth SAP BI Training Course - Unlimited Access + Updates!

Created byPeter Moxon

Last updated 10/2016

English

What you'll 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

Course content

11 sections • 59 lectures • 11h 11m total length

SAP BEx Analyzer Course – Introduction2:23
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.
Starting The BEx Analyzer2:34
This lesson will show you how to launch the BEx Analyzer
Running Queries In The BEx Analyzer10:46
Here we look at how to find and run queries. We look at History, Favourites, InfoProviders & Roles
How to open reports
The BEx Analyzer Default Query Output6:11

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 Functions of the BEx Analyzer Toolbar11:01
Here we will go through the detailed functions made available through the SAP BEx Analyzer toolbar.
BEx Analyzer Data Analysis Functions - Part 1 - Filters and Navigation options24:24
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 2 - More Filters23:09
In this video we will continue going through Navigation and Filter options in BEx reports.
BEx Analyzer Data Analysis Functions - Part 3 Characteristic & Query Properties32:13
We will continue with a focus on Filtering and Navigating the data in our report but here we will dive into Characteristic & Query Properties
Saving BEx Workbooks and Query Views4:55
Here we will go through the steps for saving queries and query views within Workbooks and saving query view independently.

Overview of the SAP BW Reporting tools landscape6:08
In this lesson we look at the architecture that makes up the SAP BW BW reporting landscape.
Starting the BEx Query Designer And Screen Layout7:49
This lesson shows how to get started with the BEx Query Designer.
BEx Query Designer Menus and Toolbar5:28
This lesson gives us a run through of the different Query Designer toolbars and menu options.
Creating our first BEx query15:07
Here we start to create a very first BEx query.
Enhance our first BEx query6:03
We will now build on the query we have created by adding more Characteristics and Key Figures
Defining filters for our BEx query15:27
The lesson will introduce filters to our query design.
Compress and Expand Key Figures and Hierarchies11:14
Lets focus on the query design with regards to formatting the output a little better by using hierarchy navigation views

Dynamic Filters1:32
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.
OLAP Variables23:49
This lesson will cover OLAP variables.
Hierarchy Variables7:52
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 Node Variables8:19
Making use of Hierarchy Node variables allow the user to make those fast hierarchy selections.
Replacement path variables17:30
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
Text Variables17:27
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.
Formula Variables9:37
Formula variables are similar to text variables to allow you to create Calculated Key Figures, exceptions and conditions.
Authorisation Variables5:38
Adding the relevant data security to your queries is easy when Authorisation variables are used. This lesson gives an overview.
SAP Exit Variables3:16
This lesson shows you how to use the SAP designed variables in your queries.
Customer Exit Variables6:27
Like SAP Exits, Customer Exits can also be used in your queries. This lessons covers how to use them and how they are created.

Selections and Formulas Overview3:36
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.
Selections20:17
This lesson with focus on Selections in Key Figures and how we create Restricted Key Figures.
Formulas11:53
This lesson will show you how to create new Key Figures using Formulas

Creating Conditions28:19
Conditions add an extra filter element to your queries. This lesson shows you how to create them.
Creating Exceptions23:34
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.
Report to Report Interfaces (RRI)34:01
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.

BEx Analysis Applications Introduction2:42
Time to switch back to the BEx Analyzer and see how we can start to build Analysis Applications.
Design Mode and the Analysis Grid20:59
This lesson takes you through all the configuration options the Analysis Grid gives you in your Analysis Applications.
Navigation Pane15:22
In this lesson you will learn how to configure and make use of the Navigation Pane - Part of the BEx design toolbar.
List of Filters6:25
Here, we go through the option offered through the Filter design item.
Add interactive Buttons27:09
Adding Buttons to you application can give your unlimited options. See how they can be setup and configured.
Drop-Down Boxes6:26
This video will show you how to configure Drop-Down boxes and attach them to your characteristics.
Check-Box Groups5:43
This video will show you how to configure Check-Box Groups and attach them to your characteristics.
Radio Button Groups4:40
This video will show you how to configure Radio Button Groups and attach them to your characteristics.
Adding Conditions5:54
Here you get to see how to add the options to enable and disable your query Conditions at report runtime.
Add Exceptions7:29
Here you get to see how to add the options to enable and disable your query Exceptions at report runtime.
Text Elements6:36
This lesson shows how to add Text Elements onto your analysis application.
BEx Messages4:07
Here you get to see how to add system messages to your reports.
Workbook Settings12:19
Here we go through the various settings you can configure to your BEx WorkBooks.

Part 1 - Introduction and Manager Report Setup6:33
AWESOME JOB!
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 2 - Employee Report Setup7:29
Here we setup the Employee report keeping in mind our application goal.
Part 3 - Multi Report Filtering with DropDown Boxes7:46
Here we pull together both reports so we can use 1 drop-down box to filter both queries at once.
Part 4 - Add a Button, Refine and Position Elements of our BEx Reports6:52
In this video we continue building the application and add an button to remove all filter values from our query.
Part 5 - Adding Dynamic Charts13:41
In this lesson we wrap things up by adding a chart to our application and reconfigure the button.

Requirements

User level understanding of how to navigate the SAP GUI or previously completed course: https://www.udemy.com/learn-sap/

Description

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.

Highlights

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 this course is for:

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

Learn SAP BEx Analyzer - Training Course

What you'll learn

Explore related topics

Course content

Getting the most out of the SAP BW BEx Analyzer9 lectures • 1hr 58min

First Steps

Creating Queries using the SAP BEx Query Designer7 lectures • 1hr 7min

Building Dynamic Selections into BEx Queries10 lectures • 1hr 41min

Structuring our queries for re-use3 lectures • 30min

Selections and Formulas3 lectures • 36min

Reusable Key Figures and Characteristics2 lectures • 12min

Properties of BEx Query Objects3 lectures • 52min

Advanced Query Options for Analyzing Data3 lectures • 1hr 26min

SAP BW BEx Analysis Applications13 lectures • 2hr 6min

Final Project - Build a BEx Analysis Application5 lectures • 42min

Requirements

Description

Who this course is for: