/
Browse
/
Courses
/
Developing Analytical Models with CDS-based Analytical Projection Views
/
Improving Flexibility of Analytical Queries using Variables
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.
Value help is always available for every prompt in the query without the need to include additional code.
Choose the correct answer.
True
False
2.
Why do we define a parameter in an analytical query?
There are two correct answers.
To cache the query results so that performance is improved
To restrict the queries to those who are authorized to execute them
To force a business user to provide a filter value before the query executes
To support the re-use of an analytical query across multiple use-cases
3.
There are two variables V1 and V2 with prompts. V2 has a derivation which has a dependency on V1. When is the derivation for the variable V2 calculated?
Choose the correct answer.
After both variable values are entered but before the query is executed
After the query results have been displayed
Before the variables are prompted
After the value for V1 has been entered