/
Browse
/
Courses
/
Developing Data Models with SAP HANA Cloud
/
Ranking Data
Preparing the Modeling Environment
Getting Started with SAP Business Application Studio
9 min
Working with Development Spaces
10 min
Creating a New Project in SAP Business Application Studio
10 min
Importing an Existing Project in SAP Business Application Studio
15 min
Navigating SAP Business Application Studio
20 min
Working with Joule in SAP Business Application Studio
5 min
Quiz
Creating Calculation Views
Understanding Basic Concepts and Terminology
18 min
Creating Dimension Calculation Views
2 min
Creating Cube Calculation Views
24 min
Creating Time-Based Dimension Calculation Views
3 min
Choosing a Data Source for a Calculation View
2 min
Checking the Output of a Calculation View
5 min
Working with Common Features of Calculation Views
26 min
Top View Node
10 min
Quiz
Working with Common Nodes in Calculation Views
Using Projection Nodes
2 min
Working with Aggregation Nodes
13 min
Quiz
Joining Data Sources in Calculation Views
Using Join Nodes
46 min
Filtering on Join Nodes
10 min
Optimizing Joins
10 min
Quiz
Working with Union Nodes in Calculation Views
Working with the Union Node
18 min
Implementing Union Pruning
16 min
Quiz
Creating Data Slices
Implementing Minus and Intersect Nodes
5 min
Quiz
Ranking Data
Implementing Rank Nodes
15 min
Quiz
Embedding Functions in Calculation Views
Generating Restricted Columns
13 min
Generating Calculated Columns
15 min
Filtering Data
37 min
Implementing Currency Conversion
20 min
Quiz
Creating Dynamic Calculation Views
Implementing Variables
15 min
Implementing Input Parameters
15 min
Mapping Variables and Input Parameters
10 min
Quiz
Implementing Hierarchies in Calculation Views
Modeling Hierarchies
36 min
Quiz
Developing Custom Logic using SQL
Introducing SAP HANA Cloud SQL Console
9 min
Implementing SQL in Calculation Views
2 min
Querying a Modeled Hierarchy Using SQL
5 min
Working with SQLScript
16 min
Creating and Using Functions
17 min
Quiz
Applying Best Practices for Modeling
Implement Recommended Modeling Practices
25 min
Implement Best Practices in calculation view nodes
10 min
Quiz
Using Tools to Check Model Performance
Validating calculation views with Performance Analysis mode
7 min
Debugging Calculation Views with the Debug Query Mode
7 min
Analyzing executions with the SQL Analyzer
5 min
Quiz
Implementing Features to Improve Performance
Controlling Parallelization
10 min
Partitioning Tables
10 min
Quiz
Storing Calculation View Results
Implementing Static Cache to Improve Performance
8 min
Creating Snapshots
12 min
Defining MDS Cubes
20 min
Quiz
Using Additional Modeling Productivity Tools
Productivity Aids for Efficient Calculation View Development
5 min
Working with Modeling Content in a Project
9 min
Quiz
Working in a Modeling Project
Project Structure
13 min
Deploying Models
11 min
Manage modeling content
36 min
Quiz
Managing the Lifecycle of a Modeling Project
Creating a Project
30 min
Enabling Access to External Data
20 min
Using Git to Manage Source Code
35 min
Deploying an Application
5 min
Quiz
Implementing Security in SAP HANA Modeling
Defining Analytic Privileges
31 min
Defining Roles
8 min
Masking Sensitive Data
7 min
Quiz
Getting Started with SAP HANA Cloud Knowledge Graph Engine
Overview of Knowledge Graphs
20 min
SAP HANA Cloud Knowledge Graph Engine
30 min
Use Cases and Demo
30 min
Quiz
Preparing the Modeling Environment
Getting Started with SAP Business Application Studio
9 min
Working with Development Spaces
10 min
Creating a New Project in SAP Business Application Studio
10 min
Importing an Existing Project in SAP Business Application Studio
15 min
Navigating SAP Business Application Studio
20 min
Working with Joule in SAP Business Application Studio
5 min
Quiz
Creating Calculation Views
Understanding Basic Concepts and Terminology
18 min
Creating Dimension Calculation Views
2 min
Creating Cube Calculation Views
24 min
Creating Time-Based Dimension Calculation Views
3 min
Choosing a Data Source for a Calculation View
2 min
Checking the Output of a Calculation View
5 min
Working with Common Features of Calculation Views
26 min
Top View Node
10 min
Quiz
Working with Common Nodes in Calculation Views
Using Projection Nodes
2 min
Working with Aggregation Nodes
13 min
Quiz
Joining Data Sources in Calculation Views
Using Join Nodes
46 min
Filtering on Join Nodes
10 min
Optimizing Joins
10 min
Quiz
Working with Union Nodes in Calculation Views
Working with the Union Node
18 min
Implementing Union Pruning
16 min
Quiz
Creating Data Slices
Implementing Minus and Intersect Nodes
5 min
Quiz
Ranking Data
Implementing Rank Nodes
15 min
Quiz
Embedding Functions in Calculation Views
Generating Restricted Columns
13 min
Generating Calculated Columns
15 min
Filtering Data
37 min
Implementing Currency Conversion
20 min
Quiz
Creating Dynamic Calculation Views
Implementing Variables
15 min
Implementing Input Parameters
15 min
Mapping Variables and Input Parameters
10 min
Quiz
Implementing Hierarchies in Calculation Views
Modeling Hierarchies
36 min
Quiz
Developing Custom Logic using SQL
Introducing SAP HANA Cloud SQL Console
9 min
Implementing SQL in Calculation Views
2 min
Querying a Modeled Hierarchy Using SQL
5 min
Working with SQLScript
16 min
Creating and Using Functions
17 min
Quiz
Applying Best Practices for Modeling
Implement Recommended Modeling Practices
25 min
Implement Best Practices in calculation view nodes
10 min
Quiz
Using Tools to Check Model Performance
Validating calculation views with Performance Analysis mode
7 min
Debugging Calculation Views with the Debug Query Mode
7 min
Analyzing executions with the SQL Analyzer
5 min
Quiz
Implementing Features to Improve Performance
Controlling Parallelization
10 min
Partitioning Tables
10 min
Quiz
Storing Calculation View Results
Implementing Static Cache to Improve Performance
8 min
Creating Snapshots
12 min
Defining MDS Cubes
20 min
Quiz
Using Additional Modeling Productivity Tools
Productivity Aids for Efficient Calculation View Development
5 min
Working with Modeling Content in a Project
9 min
Quiz
Working in a Modeling Project
Project Structure
13 min
Deploying Models
11 min
Manage modeling content
36 min
Quiz
Managing the Lifecycle of a Modeling Project
Creating a Project
30 min
Enabling Access to External Data
20 min
Using Git to Manage Source Code
35 min
Deploying an Application
5 min
Quiz
Implementing Security in SAP HANA Modeling
Defining Analytic Privileges
31 min
Defining Roles
8 min
Masking Sensitive Data
7 min
Quiz
Getting Started with SAP HANA Cloud Knowledge Graph Engine
Overview of Knowledge Graphs
20 min
SAP HANA Cloud Knowledge Graph Engine
30 min
Use Cases and Demo
30 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 1 right to pass this unit.
1.
Why might you implement a rank node?
There are two correct answers.
To identify the best selling products in each region for each of the last 5 years.
To identify the training courses that represent the bottom 10%, based on bookings per year.
To order the sales amount by country and product each year.
To sort the sales amounts by product in decreasing order.