Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting the most out of the SAP BW BEx Analyzer|
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:
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.
|This lesson will show you how to launch the BEx Analyzer|
Here we look at how to find and run queries. We look at History, Favourites, InfoProviders & Roles
|Quiz 1||1 question|
Test your knowledge on how to open existing BEx reports
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.
Here we will go through the detailed functions made available through the SAP 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.|
|In this video we will continue going through Navigation and Filter options in BEx reports.|
|We will continue with a focus on Filtering and Navigating the data in our report but here we will dive into Characteristic & Query Properties|
|Here we will go through the steps for saving queries and query views within Workbooks and saving query view independently.|
|Section 2: Creating Queries using the SAP BEx Query Designer|
In this lesson we look at the architecture that makes up the SAP BW BW reporting landscape.
|This lesson shows how to get started with the BEx Query Designer.|
|This lesson gives us a run through of the different Query Designer toolbars and menu options.|
|Here we start to create a very first BEx query.|
|We will now build on the query we have created by adding more Characteristics and Key Figures|
|The lesson will introduce filters to our query design.|
|Lets focus on the query design with regards to formatting the output a little better by using hierarchy navigation views|
|Section 3: Building Dynamic Selections into BEx Queries|
|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.|
|This lesson will cover 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.
|Making use of Hierarchy Node variables allow the user to make those fast hierarchy selections.|
|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|
|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 variables are similar to text variables to allow you to create Calculated Key Figures, exceptions and conditions.|
|Adding the relevant data security to your queries is easy when Authorisation variables are used. This lesson gives an overview.|
|This lesson shows you how to use the SAP designed variables in your queries.|
Like SAP Exits, Customer Exits can also be used in your queries. This lessons covers how to use them and how they are created.
|Section 4: Structuring our queries for re-use|
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.|
Here we go into a more detailed discussion on reusing and managing structures.
|Section 5: Selections and Formulas|
|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.|
|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|
|Section 6: Reusable Key Figures and Characteristics|
Now you know how to create restrictions on our key figures, lets see how we can create Restricted Key Figures (RKF's)
|Now you know how to create formulas, lets see how we can create Calculated Key Figures (CKF's)|
|Section 7: Properties of BEx Query Objects|
|This lesson will focus on the specific Characteristic properties you can set in your queries.|
|This lesson will focus on the specific Key Figure properties you can set in your queries.|
|This lesson will focus on the Query properties as a whole.|
|Section 8: Advanced Query Options for Analyzing Data|
|Conditions add an extra filter element to your queries. This lesson shows you how to create them.|
|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'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.|
|Section 9: SAP BW BEx Analysis Applications|
|Time to switch back to the BEx Analyzer and see how we can start to build Analysis Applications.|
|This lesson takes you through all the configuration options the Analysis Grid gives you in your Analysis Applications.|
|In this lesson you will learn how to configure and make use of the Navigation Pane - Part of the BEx design toolbar.|
|Here, we go through the option offered through the Filter design item.|
|Adding Buttons to you application can give your unlimited options. See how they can be setup and configured.|
|This video will show you how to configure Drop-Down boxes and attach them to your characteristics.|
|This video will show you how to configure Check-Box Groups and attach them to your characteristics.|
|This video will show you how to configure Radio Button Groups and attach them to your characteristics.|
|Here you get to see how to add the options to enable and disable your query Conditions at report runtime.|
Here you get to see how to add the options to enable and disable your query Exceptions at report runtime.
This lesson shows how to add Text Elements onto your analysis application.
|Here you get to see how to add system messages to your reports.|
|Here we go through the various settings you can configure to your BEx WorkBooks.|
|Section 10: Final Project - Build a BEx Analysis Application|
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!
|Here we setup the Employee report keeping in mind our application goal.|
|Here we pull together both reports so we can use 1 drop-down box to filter both queries at once.|
|In this video we continue building the application and add an button to remove all filter values from our query.|
|In this lesson we wrap things up by adding a chart to our application and reconfigure the button.|
|Section 11: Course Wrap-Up|
|Course wrap up.|