/
Browse
/
Courses
/
Developing Data Models with SAP HANA Cloud
/
Embedding Functions 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 3 right to pass this unit.
1.
Filters can be defined on attributes but not measures - true or false?
Choose the correct answer.
True
False
2.
Why might you create a restricted column?
Choose the correct answer.
To generate a filtered column to simplify the creation of calculated columns
To define rules for a measure that must be protected from unauthorized viewing
3.
Why should you implement currency conversion in an SAP HANA Cloud calculation view instead of in reporting tools?
There are two correct answers.
Performance is usually better
Ensure consistency of results across reports
Easier for business users to adjust the conversion settings
4.
A calculated column can generate an attribute or a measure?
Choose the correct answer.
True
False