SAP Training: SAP BI BEx Query Designer
SAP BI BEx Query Designer

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



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:

Instructor

Michael Management Instructor Team

4.6 Average Rating

347 Reviews

12494 Students

124 Courses

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 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 CRM - Sales Manager

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 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 MM Inventory Management Configuration

  (5.0)

SAP Materials Requirements Planning (MRP)

  (4.6)

SAP Bank Accounting

  (4.7)

SAP Security Administration

  (5.0)

Basic SAP Internal Orders

  (4.0)

Intermediate SAP System Administration

  (4.0)

SAP User Administration

  (5.0)

SAP MM Purchasing Configuration

  (5.0)

SAP MM Consumption-Based Planning Configuration

  (5.0)

SAP MM Master Data Configuration

  (4.3)

Intermediate SAP Purchasing

  (5.0)

SAP Quality Management - Inspection Planning

  (4.0)

SAP Quality Management - Inspection Execution

  (5.0)

SAP Outline Agreements

  (4.7)

Intermediate SAP Accounts Receivable

  (4.7)

SAP New General Ledger

  (5.0)

SAP SD Pricing Configuration

  (5.0)

SAP MM Enterprise Structure Configuration

  (4.6)

Intermediate SAP Accounts Payable

  (4.6)

SAP SD Master Data Configuration

  (5.0)

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 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 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)



Student Feedback

Not Enough Reviews Yet




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 SAP students

students enrolled.
Join them!


SAP Student testimonial
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

>