Getting the most out of the SAP BW BEx Analyzer
  • SAP BEx Analyzer Course – Introduction
  • Starting The BEx Analyzer
  • Running Queries In The BEx Analyzer
  • How to open reports
  • The BEx Analyzer Default Query Output
  • The Functions of the BEx Analyzer Toolbar
  • BEx Analyzer Data Analysis Functions - Part 1 - Filters and Navigation options
  • BEx Analyzer Data Analysis Functions - Part 2 - More Filters
  • BEx Analyzer Data Analysis Functions - Part 3 Characteristic & Query Properties
  • Saving BEx Workbooks and Query Views
Creating Queries using the SAP BEx Query Designer
  • Overview of the SAP BW Reporting tools landscape
  • Starting the BEx Query Designer And Screen Layout
  • BEx Query Designer Menus and Toolbar
  • Creating our first BEx query
  • Enhance our first BEx query
  • Defining filters for our BEx query
  • Compress and Expand Key Figures and Hierarchies
Building Dynamic Selections into BEx Queries
  • Dynamic Filters
  • OLAP Variables
  • Hierarchy Variables
  • Hierarchy Node Variables
  • Replacement path variables
  • Text Variables
  • Formula Variables
  • Authorisation Variables
  • SAP Exit Variables
  • Customer Exit Variables
Structuring our queries for re-use
  • Structures
  • Cell Definitions
  • Reusing Structures
Selections and Formulas
  • Selections and Formulas Overview
  • Selections
  • Formulas
Reusable Key Figures and Characteristics
  • Restricted Key Figures
  • Calculated Key Figures
Properties of BEx Query Objects
  • Characteristic Query Element Properties
  • Key Figure Query Element Properties
  • Query Element Properties
Advanced Query Options for Analyzing Data
  • Creating Conditions
  • Creating Exceptions
  • Report to Report Interfaces (RRI)
SAP BW BEx Analysis Applications
  • BEx Analysis Applications Introduction
  • Design Mode and the Analysis Grid
  • Navigation Pane
  • List of Filters
  • Add interactive Buttons
  • Drop-Down Boxes
  • Check-Box Groups
  • Radio Button Groups
  • Adding Conditions
  • Add Exceptions
  • Text Elements
  • BEx Messages
  • Workbook Settings
Final Project - Build a BEx Analysis Application
  • Part 1 - Introduction and Manager Report Setup
  • Part 2 - Employee Report Setup
  • Part 3 - Multi Report Filtering with DropDown Boxes
  • Part 4 - Add a Button, Refine and Position Elements of our BEx Reports
  • Part 5 - Adding Dynamic Charts
Course Wrap-Up
  • Course Complete and THANKYOU