Audience

Application Consultant
Business Analyst
Business Process Owner / Team Lead / Power User
Program / Project Manager
User

Certification

–

Exam

–

Investment

Instructor-led / Virtual Instructor-led

Singapore: Upon Request

PREREQUISITES

Essential

Basic knowledge of data warehousing

Recommended

Experience and sound knowledge of the subject matter in at least one SAP
ERP application course

OBJECTIVES

This course will prepare you to:

Learn how to create queries in BEx Query Designer
Learn how to use advanced query functions
Learn how to perform OLAP Analysis

COURSE CONTENT

Module 1: Data Warehousing

Describing Data Warehousing
Describing Data Warehouse Architecture
Using Reporting Tools

Module 2: Navigation Options in Reports

Using the Navigation Options in Reports
Saving Analysis Views and Workbooks

Module 3: Simple Queries

Creating Simple Queries
Finding a Query
Filtering Query Definition Data
Configuring Query Properties

Module 4: Key Figures and Structures in Queries

Creating Restricted Key Figures
Creating Calculated Key Figures
Creating a New Formula with Boolean Operators
Configuring Properties of Key Figures
Using Exception and Nested Exception Aggregation

Module 5: Queries with Multiple Structures

Creating Structures
Resolving Formula Collision
Designing Detailed Queries with the Cell Editor

Module 6: Characteristics and Hierarchies in Queries

Configuring the Properties of Characteristics
Running Display and Navigation Attribute Queries
Adding Hierarchies to Reports
Using Hierarchies and Structures
Adding External Hierarchies to a Report
Creating External Hierarchies

Module 7: Variables in Queries

Using Variables
Creating Characteristic Value and Text Variables in Queries
Creating Hierarchy and Hierarchy Node Variables in Queries
Creating Formula Variables in Queries
Activating Business Content Variables

Module 8: Exceptions and Conditions in Queries

Creating Exceptions in Query Design
Creating Conditions in Query Design

Module 9: Report-Report Interface

Using the Report-Report Interface

Module 10: Query Performance Optimization

Optimizing Query Performance
Configuring Query Read Mode
Using Performance Monitoring Tools

Module 11: Queries Management and Authorizations Overview

Managing Query Objects
Describing Authorizations

Module 12: Reporting Options

Outlining Reporting Options for SAP BW

What’s Next

SAP Business Warehouse Query Design and Analysis