/
Browse
/
Courses
/
Developing Data Models with SAP HANA Cloud
/
Joining Data Sources in Calculation Views
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
41 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
41 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 5 right to pass this unit.
1.
When do you implement a non-equi join?
Choose the correct answer.
When your match is not on an exact value of a column
When your data sources are in different source systems
When you want to match on different data types
2.
Which are options for specifying the multi-join order?
There are two correct answers.
Inside-Out
Left-to-Right
Outside-In
Right-to-Left
3.
What can you achieve by mapping a filter defined on a join node?
There are two correct answers.
Data consistency in the result set
Pruning one of the joined data sources
Better performance of join execution
Make sure the two data sources contain the same number of rows after filtering
4.
What do you implement to allow data analysis at different levels of granularity with the same calculation view?
Choose the correct answer.
Non-equi join
Referential join
Dynamic join
5.
What is the primary objective of join pruning?
Choose the correct answer.
To simplify the design of a calculation view for easier maintenance
To improve the performance of a calculation view
6.
How does a referential join type improve performance?
Choose the correct answer.
By pruning joins
By filtering the data
By combining similar joins