With this course, you will learn how to develop powerful analytical queries using ABAP Core Data Services, that can be consumed by analytical applications.
MIT Sloan: Lead AI Adoption Across Your Organization — Not Just Pilot It
Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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