/
Browse
/
Courses
/
Developing Analytical Models with CDS-based Analytical Projection Views
/
Exploring the Underlying Data Model of an Analytical Query
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 are components of the star schema?
There are two correct answers.
Cube View
Value Help View
Analytical Projection View
Dimension View
2.
Which is the correct annotation to define a CDS view as a cube?
Choose the correct answer.
@ObjectModel.dataCategory: #TEXT
@Analytics.dataCategory: #DIMENSION
@Analytics.dataCategory: #CUBE
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_PROVIDER ]
3.
What is the purpose of the annotation @ObjectModel.representativeKey?
Choose the correct answer.
To define an alias for a dimension field
To define the key field which represents the dimension or text view
To define the foreign key associations to the text views
4.
Which types of CDS views can be used with the Relation Explorer in the context of analytical content?
There are two correct answers.
dataCategory: #CUBE
dataCategory: #TEXT
dataCategory: #DIMENSION
dataCategory: #HIERARCHY