Getting Started with Analytical Queries

Exploring the Underlying Data Model of an Analytical Query

Creating a Simple Analytical Query

Working with Dimensions in an Analytical Query

Working with Measures in an Analytical Query

Improving Flexibility of Analytical Queries using Variables

Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

Knowledge quiz

It’s time to put what you’ve learned to the test, get 3 questions right to pass this unit.

Choose the correct answer.

To define an analytical query

To expose fields for extraction to a data pipeline

To support direct access to ABAP tables using SQL tools

To define a star schema

Choose the correct answer.

ABAP column table

CDS analytical projection view

CDS view defined as a cube

SAP HANA calculation view

Choose the correct answer.

To enable editing the CDS view using Microsoft Visual Studio IDE

To identify the location of the CDS view in the ABAP package structure.

To define the default editor that launches when you open a CDS view

To mark a CDS view as requiring editing before it is released

There are two correct answers.

Modeling Tools for SAP BW/4HANA

ABAP Development Tools (ADT)

SAP GUI

Eclipse

Learning