/
Browse
/
Courses
/
Developing Analytical Models with CDS-based Analytical Projection Views
/
Working with Dimensions in 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 4 right to pass this unit.
1.
By default, all values for a dimension are displayed in a query result regardless of whether they have an assigned measure (booked) or not.
Choose the correct answer.
True
False
2.
To provide text for a dimension value you can define a text association in the analytical query to a text view.
Choose the correct answer.
True
False
3.
What is a display attribute?
Choose the correct answer.
A setting that defines the number of decimal places for a measure
The co-ordinates of a cell in a query used in formulas
A query element that provides additional information about a dimension value
A setting that defines if a field should be displayed or hidden by default
4.
A hierarchy CDS view is required to enable a Universal Display Hierarchy.
Choose the correct answer.
True
False
5.
You can combine a universal display hierarchy with a display hierarchy in the same query.
Choose the correct answer.
True
False