With this course, you will learn how to develop powerful analytical queries using ABAP Core Data Services, that can be consumed by analytical applications.
The Most Addictive Python and SQL Courses
Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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