With this course, you will learn how to develop powerful analytical queries using ABAP Core Data Services, that can be consumed by analytical applications.
Get Coursera Plus for 40% off
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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