With this course, you will learn how to develop powerful analytical queries using ABAP Core Data Services, that can be consumed by analytical applications.
Earn Your CS Degree, Tuition-Free, 100% Online!
Build with Azure OpenAI, Copilot Studio & Agentic Frameworks — Microsoft Certified
Overview
Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Syllabus
- Getting Started with Analytical Models and Queries
- Describing the Role of a CDS Analytical Projection View
- Preparing the Development Environment
- Getting Started with Analytical Models and Queries
- Exploring the Underlying Data Model of an Analytical Query
- 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
- Creating a Simple Analytical Query
- Describing the Key Elements of an Analytical Query
- Creating a Simple Analytical Query
- Key Settings of an Analytical Query
- Creating a Simple Analytical Query
- Working with Dimensions in an 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
- Working with Measures in an Analytical Query
- Introducing Measures
- Defining Restricted Measures
- Defining Calculated Measures
- Working with Measures in an Analytical Query
- Improving Flexibility of Analytical Queries using Variables
- Defining Basic Variables
- Defining Default Values for Variables
- Providing Value Help
- Improving Flexibility of Analytical Queries using Variables
- Working with Structures in an Analytical Query
- Defining a Measure Structure
- Defining a Characteristic Structure
- Working with Exception Cells
- Working with Structures in an Analytical Query