/
Browse
/
Courses
/
Developing Analytical Models with CDS-based Analytical Projection Views
/
Getting Started with Analytical Models and Queries
Getting Started with Analytical Models and Queries
Describing the Role of a CDS Analytical Projection View
5 min
Preparing the Development Environment
6 min
Quiz
Exploring the Underlying Data Model of an Analytical Query
Describing the underlying data model of a CDS analytical projection view
10 min
Working with Cube Views
10 min
Working with Dimension and Text Views
10 min
Working with Hierarchy Views
20 min
Exploring the Star Schema
5 min
Quiz
Creating a Simple Analytical Query
Describing the Key Elements of an Analytical Query
10 min
Creating a Simple Analytical Query
10 min
Key Settings of an Analytical Query
10 min
Quiz
Working with Dimensions in an Analytical Query
Including Texts in an Analytical Query
10 min
Including Attributes in an Analytical Query
10 min
Including Hierarchies in an Analytical Query
20 min
Properties of Dimensions
10 min
Quiz
Working with Measures in an Analytical Query
Introducing Measures
5 min
Defining Restricted Measures
30 min
Defining Calculated Measures
50 min
Quiz
Improving Flexibility of Analytical Queries using Variables
Defining Basic Variables
20 min
Defining Default Values for Variables
14 min
Providing Value Help
10 min
Quiz
Working with Structures in an Analytical Query
Defining a Measure Structure
10 min
Defining a Characteristic Structure
10 min
Working with Exception Cells
10 min
Quiz
Getting Started with Analytical Models and Queries
Describing the Role of a CDS Analytical Projection View
5 min
Preparing the Development Environment
6 min
Quiz
Exploring the Underlying Data Model of an Analytical Query
Describing the underlying data model of a CDS analytical projection view
10 min
Working with Cube Views
10 min
Working with Dimension and Text Views
10 min
Working with Hierarchy Views
20 min
Exploring the Star Schema
5 min
Quiz
Creating a Simple Analytical Query
Describing the Key Elements of an Analytical Query
10 min
Creating a Simple Analytical Query
10 min
Key Settings of an Analytical Query
10 min
Quiz
Working with Dimensions in an Analytical Query
Including Texts in an Analytical Query
10 min
Including Attributes in an Analytical Query
10 min
Including Hierarchies in an Analytical Query
20 min
Properties of Dimensions
10 min
Quiz
Working with Measures in an Analytical Query
Introducing Measures
5 min
Defining Restricted Measures
30 min
Defining Calculated Measures
50 min
Quiz
Improving Flexibility of Analytical Queries using Variables
Defining Basic Variables
20 min
Defining Default Values for Variables
14 min
Providing Value Help
10 min
Quiz
Working with Structures in an Analytical Query
Defining a Measure Structure
10 min
Defining a Characteristic Structure
10 min
Working with Exception Cells
10 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 3 right to pass this unit.
1.
Which tools must you install to setup the development environment of CDS analytical projection views?
There are two correct answers.
Modeling Tools for SAP BW/4HANA
ABAP Development Tools (ADT)
SAP GUI
Eclipse
2.
Which of these data sources can be consumed by an CDS analytical projection view?
Choose the correct answer.
ABAP column table
CDS analytical projection view
CDS view defined as a cube
SAP HANA calculation view
3.
What is the purpose of a CDS analytical projection view?
Choose the correct answer.
To define an analytical query
To expose fields for extraction to a data pipeline
To support direct access to ABAP tables using SQL tools
To define a star schema
4.
Why do I enable the setting Link with Editor in ADT?
Choose the correct answer.
To enable editing the CDS view using Microsoft Visual Studio IDE
To identify the location of the CDS view in the ABAP package structure.
To define the default editor that launches when you open a CDS view
To mark a CDS view as requiring editing before it is released