Share your recently acquired knowledge across your social and professional networks.

{learning-journey-title}

Record of Achievement

ROA_general_gerneric_Template.png

Pass all the quizzes and receive a digital badge

Record of Achievement

More content coming soon

We are constantly working to bring you content that keeps your knowledge and skills ahead of the game. &nbsp;More content coming soon.

Coming Soon

SAP Learning Group

Smiling coworkers looking at computer while working in office - stock photo

298119_16_9.jpg

Join our&nbsp;SAP Learning Group moderated by an SAP Learning expert. Ask your questions about digital learning journeys,&nbsp;prepare thoroughly for SAP Certification exams, and work together with other learners to reach your learning goals.

SAP Learning Group

Scrolling tab | Developing Analytical Queries using ABAP Core Data Services

Share feedback

Planned maintenance of Practice Systems

Planned maintenance of Practice Systems

Why create an SAP account?

Enhance your learning experience

SAP Learning

Subscribe now

Learn more

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

cleanFiles/bookmap_Developing_Analytical_Queries_using_CDS_Pr_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-02-14T11:40:23.000Z

Describing the Role of a CDS Analytical Projection View

Preparing the Development Environment

Assessment

Getting Started with Analytical Queries

Describing the underlying data model of a CDS analytical projection view

Working with Cube Views

Working with Dimension and Text Views

Working with Hierarchy Views

Exploring the Star Schema

Exploring the Underlying Data Model of an Analytical Query

Describing the Key Elements of an Analytical Query

Creating Your First Analytical Query

Key Settings of an Analytical Query

Creating a Simple Analytical Query

Including Texts in an Analytical Query

Including Attributes in an Analytical Query

Including Hierarchies in an Analytical Query

Properties of Dimensions

Working with Dimensions in an Analytical Query

Introducing Measures

Defining Restricted Measures

Defining Calculated Measures

Working with Measures in an Analytical Query

Defining Basic Variables

Defining Default Values for Variables

Providing Value Help

Improving Flexibility of Analytical Queries using Variables

Developing Analytical Queries using ABAP Core Data Services

With this Learning Journey, you will learn how to develop powerful analytical queries using ABAP Core Data Services, that can be consumed by analytical applications.

1_qs6qw6uv (video-connector) - 2025-02-12T14:07:17.437Z

Analytical queries play an essential role in selecting data sets for consumption by analytical tools, such as SAP Analytics Cloud or other business intelligence tools. Analytical queries express the business logic and prepare data for exploration by the business user. Analytical queries are developed using App App Core Data Services in the App App Development Environment. This course will help you to develop skills in this popular topic. We begin by explaining the role of the analytical query and how to set up the environment to begin development. We then briefly explore the underlying data model so that we understand the type of data available to the analytical query. Next, we show you how to develop your first simple analytical query before we dive into the details. You can check your progress using assessment questions throughout the course. So jump in and get started developing analytical queries using App AppCore data services.