Data, Analytics & AI Category Banner Image

SAP Business Warehouse - Query Design and Analysis (BW305)

Length 5 days

Course overview

View dates &
book now

Why study this course

This course gives you the knowledge to create query definitions using the Bex Query and to make them available for OLAP Analysis.

This course is based on software release:

BW 7.4

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

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

SAP at Lumify Work

Develop your SAP empowered employees with Lumify Work. Getting the right skills in place maximises the chance of project success and removes risk. Lumify Work provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. Lumify Work can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality Instructors and Content

Expert instructors with real world experience and the latest vendor-approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world's leading vendors as preferred training partner.

Ahead of the Technology Curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

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

Course subjects

Data Warehousing

Describing Data Warehousing
Describing Data Warehouse Architecture
Using Reporting Tools

Navigation Options in Reports

Using the Navigation Options in Reports
Saving Workbooks, Analysis Views and Query Views

Simple Queries

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

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

Queries with Multiple Structures

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

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

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

Exceptions and Conditions in Queries

Creating Exceptions in Query Design
Creating Conditions in Query Design

Report-Report Interface

Using the Report-Report Interface

Query Performance Optimisation

Optimising Query Performance
Configuring Query Read Mode
Using Performance Monitoring Tools

Queries Management and Authorisations Overview

Managing Query Objects
Describing Authorisations

Reporting Options

Outlining Strategy and Portfolio: SAP Analytics
Outlining BEx Reporting Options for SAP BW

Prerequisites

Essential

Basic knowledge of data warehousing

Recommended

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

THIRD PARTY REGISTRATION

Lumify Work offers certification and training through our partnership with SAP Inc. This arrangement requires Lumify Work to provide your details to SAP Inc for course and/or exam registration purposes.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.