BI102

SAP BI BEx Query Designer

Be able to design queries using the BEx Query Designer. Easily create comprehensive reports and analytics using SAP's Business Information (aka Business Warehouse) system. BEx Query Designer skills are a basic requirement for anyone working with SAP BI.

In this course you will learn:

Not Enough Reviews Yet

Course Goal

BEx Query Designer overview
Working with infoproviders and variables
Free characteristics and custom formulas
Exceptions, conditions and variables
Multiple structures, nested selections and hierarchies

Audience

Consultants
End users
IT/Business analysts
Project team members

Exam/Certificate

Formal final exam (timed and graded, see sample SAP exam)
Certificate of Completion (more certification info)
Qualifies for Certified SAP Professional designation (view)

Lesson Plan

Lesson	Description	Preview
1	Introduction to BEx Query Designer	Preview
2	Infoproviders
3	Query-level restrictions
4	Using existing variables
5	Rows, columns and free characteristics
6	Custom formulas
7	Exceptions
8	Conditions
9	Selection-level restrictions
10	Variable selections and text variables
11	Multiple structures and nested selections
12	Building hierarchies
13	Hierarchies in BEx Query Designer

Career Paths

This training course is included in the following SAP Career Paths:

SAP Business Objects Developer

Business Warehouse Analyst

Instructor

4.6 Average Rating

347 Reviews

12494 Students

124 Courses

Michael Management Instructor Team

New York, NY

This course was developed by the Michael Management Instructor Team. We're passionate about creating the best possible training courses for you and constantly look for ways to make your training more fun and engaging.

More Courses by Michael Management Instructor Team :

SAP S/4 HANA Intermediate SAP Skills

(4.8)

SAP S/4 HANA - Intermediate Reporting Skills

(4.5)

SAP S/4 HANA - Basic Navigation

(4.7)

SAP S/4 HANA - Basic Reporting Skills

(4.5)

SAP ABAP Working with Data Basics

(5.0)

SAP ABAP Intro to Editing & Operators

(4.8)

SAP Accounts Payable Reporting

(4.5)

SAP General Ledger Reporting

No Ratings yet

SAP Accounts Receivable Reporting

(4.0)

Basic SAP Navigation

(4.5)

SAP Central Controlling Configuration

(4.5)

SAP BusinessObjects Web Intelligence

(5.0)

SAP SuccessFactors Overview

(5.0)

SAP Profitability Analysis

(4.0)

SAP LSMW - Legacy System Migration Workbench

(5.0)

SAP Actual Costing / Material Ledger

(4.0)

SAP HR CATS Time Sheets

No Ratings yet

SAP Production Planning - Capacity Planning

No Ratings yet

SAP CRM - Sales Manager

No Ratings yet

SAP Solutions Overview ERP

No Ratings yet

SAP Sales and Distribution Overview

(4.0)

SAP GRC Access Control

No Ratings yet

SAP Controlling Overview

(4.3)

SAP HANA - Studio Installation and Deployment

(4.5)

SAP HANA - Modeling and Administration

(5.0)

SAP HR - Time Management

(5.0)

SAP Materials Management Overview

(4.2)

SAP Bank Accounting Configuration II

(5.0)

SAP MM Invoice Verification Configuration

(5.0)

SAP Collections Management

No Ratings yet

SAP Query Reporting

(4.0)

SAP System Administration

No Ratings yet

SAP Dispute Management

(4.0)

SAP Customer Service

(5.0)

SAP Financial Period End Closing

(4.0)

SAP Bank Accounting Configuration I

(5.0)

SAP Product Costing - Cost Object Controlling

No Ratings yet

SAP MM Inventory Management Configuration

(5.0)

SAP Materials Requirements Planning (MRP)

(4.6)

SAP Product Costing - Planning

No Ratings yet

SAP Bank Accounting

(4.7)

Intermediate SAP Bank Accounting

No Ratings yet

SAP Security Administration

(5.0)

Basic SAP Internal Orders

(4.0)

Intermediate SAP Internal Orders

No Ratings yet

Intermediate SAP System Administration

(4.0)

SAP User Administration

(5.0)

SAP MM Purchasing Configuration

(5.0)

SAP Asset Accounting Reporting

No Ratings yet

SAP MM Consumption-Based Planning Configuration

(5.0)

SAP MM Master Data Configuration

(4.3)

SAP SD Billing Configuration

No Ratings yet

SAP Production Planning - Process Industries

No Ratings yet

SAP SD Sales Document Configuration

No Ratings yet

SAP Production Planning - Repetitive Manufacturing

No Ratings yet

Intermediate SAP Purchasing

(5.0)

SAP Quality Management - Inspection Planning

(4.0)

SAP Quality Management - Inspection Execution

(5.0)

SAP Advanced Web Application Designer

No Ratings yet

Winshuttle - Journal Entry

No Ratings yet

SAP Solution Manager - Implementation

No Ratings yet

SAP Web Application Designer

No Ratings yet

SAP Outline Agreements

(4.7)

Intermediate SAP Accounts Receivable

(4.7)

SAP Intermediate Financial Accounting

No Ratings yet

SAP New General Ledger

(5.0)

SAP SD Pricing Configuration

(5.0)

SAP CRM - Sales Professional

No Ratings yet

SAP MM Enterprise Structure Configuration

(4.6)

Intermediate SAP Accounts Payable

(4.6)

SAP SD Delivery Configuration

No Ratings yet

SAP Project System - Planning

No Ratings yet

SAP SD Master Data Configuration

(5.0)

SAP Project System - Reporting

No Ratings yet

SAP Quotations

(4.8)

SAP Employee Self-Service

No Ratings yet

Intermediate SAP General Ledger

(5.0)

SAP SD - Deliveries

(5.0)

Winshuttle - Transaction

(5.0)

Intermediate SAP Skills

(4.6)

SAP SD Enterprise Structure Configuration

(5.0)

SAP SD - Credit Memo Processing

(4.0)

Intermediate SAP Material Master Data

(4.6)

Intermediate SAP Sales & Distribution

(4.3)

SAP Material Master Data

(4.8)

SAP HR - Basic Payroll

(4.0)

Intermediate SAP Asset Accounting

(5.0)

SAP Assets under Construction

(5.0)

SAP HR - Org. Management Reporting

(5.0)

SAP Human Resources Overview

(5.0)

Intermediate SAP Reporting Skills

(4.9)

Essential SAP Skills

No Ratings yet

Basic SAP Reporting Skills

(4.6)

Intermediate SAP Plant Maintenance

(3.5)

SAP HR - Organizational Management

(5.0)

SAP Plant Maintenance

(4.0)

SAP FI-AP/AR Configuration II

(5.0)

SAP FI-AP/AR Configuration I

(5.0)

SAP Asset Accounting Configuration I

(5.0)

SAP Asset Accounting Configuration II

No Ratings yet

SAP Investment Management

No Ratings yet

SAP FI-GL Configuration

(4.8)

SAP Financial Accounting Overview

(5.0)

Introduction to SAP Configuration

(5.0)

SAP Enterprise Structure Configuration

(4.5)

SAP Global FI Configuration

(4.5)

SAP BI BEx Analyzer

(4.5)

SAP Production Planning - Discrete Manufacturing

(4.5)

Basic SAP System Administration

(4.7)

SAP Warehouse Management

(4.5)

SAP Inventory Management

(4.6)

SAP Profit Center Accounting

No Ratings yet

SAP Cost Center Accounting

(4.0)

SAP Purchasing

(4.9)

SAP Sales and Distribution

(4.4)

SAP General Ledger Accounting

(5.0)

SAP Accounts Receivable Accounting

(4.4)

SAP Accounts Payable Accounting

(4.8)

SAP HR - Personnel Administration

(5.0)

SAP Project System - Project Builder

(4.0)

SAP Asset Accounting

(5.0)

Basic SAP Skills

(4.5)

SAP Solution Manager - Test Management

No Ratings yet

Annual Subscription to All Courses $1599 Or Subscribe to this individual course for $329

Student Feedback

Not Enough Reviews Yet

Annual Subscription to All Courses

$1599

Subscribe to this individual course for $329

Level:	Beginner
Duration:	6.5 hours
Type:	Simulation
Delivery:	Online, self-study
Release:	BI 7.0
Category:	SAP Business Warehouse
Exam:	100+ questions

Share this course with a friend

387

students enrolled.
Join them!

I had no detailed knowledge of SAP Solution Manager and MMC training allowed me to progress quickly in the functions of my present job.
-Alejandro F.

SAP Analyst
Pharmascience Inc.

Related Training

Training 10 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses