Course

Creating Queries in SAP BW/4HANA

About this course

After completing this course, you will be able to:

Work with the eclipse-based SAP BW/4HANA Query Designer tool
Build basic SAP BW/4HANA Queries
Define Restricted and Calculated Key Figures
Implement Structures in SAP BW/4HANA Queries
Enrich SAP BW/4HANA Queries with Attributes and Hierarchies
Increase the flexibility of SAP BW/4HANA Queries by using Variables
Define Exceptions and Conditions in SAP BW/4HANA Queries
Optimize SAP BW/4HANA Query Performance
Manage SAP BW/4HANA Queries and reusable Query components
Expand the query results by using the Report-Report Interface

Learn

Unit 1

Creating Simple Queries

1 Lesson
32 min

1

Unit 2

Configuring Key Figures in Queries

5 Lessons
1 hr 11 min

2

Unit 3

Implementing Structures in Queries

2 Lessons
28 min

3

Unit 4

Configuring Characteristic Properties, Attributes, and Hierarchies

3 Lessons
37 min

4

Unit 5

Implementing Variables in Queries

7 Lessons
1 hr 25 min

5

Unit 6

Defining Exceptions and Conditions in Queries

2 Lessons
26 min

6

Unit 7

Working with the Report-Report Interface

1 Lesson
8 min

7

Unit 8

Optimizing Query Performance

2 Lessons
27 min

8

Unit 9

Managing Queries and Reusable Query Components

1 Lesson
31 min

9

Available in

German Spanish French Japanese Korean Portuguese Chinese

Other ways to learn

Paid enrollment

Learn with an instructor

Join scheduled live courses led by experienced SAP trainers.

Prerequisites

Getting Started Building an On-Premise Data Warehouse using SAP BW/4HANA

Products and Roles

ConsultantBusiness UserData AnalystSAP BW/4HANASAP Business Data Cloud

Appears in

Learning Journey: Exploring SAP BW/4HANA