/
Browse
/
Courses
/
Developing Analytical Models with CDS-based Analytical Projection Views
/
Creating a Simple 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 header-level annotation must be included to avoid an activation error?
Choose the correct answer.
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ObjectModel.modelingPattern: #ANALYTICAL_QUERY
@EndUserText.label: … your label goes here ...
@ObjectModel.supportedCapabilities: [#ANALYTICAL_QUERY]
2.
Which settings can usually be changed by the business user in the front end tools?
There are two correct answers.
display sub-totals
definition of restricted measures
the sorting rules
exception aggregation behavior
3.
An analytical query can include some measures that have been assigned to the rows axis and some measures that have been assigned to the columns axis.
Choose the correct answer.
True
False