/
Browse
/
Courses
/
Developing Data Models with SAP HANA Cloud
/
Creating 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 7 right to pass this unit.
1.
Which of the following are supported data source types for calculation view consumption?
There are four correct answers.
Calculation views
Flat files
Virtual tables
Column tables
Row tables
2.
Why do you create a time-based dimension calculation view?
Choose the correct answer.
To define a calculation view that is valid for a specific period of time
To automatically generate time-related attributes from a base date
To generate historical views of master data
3.
What is the name of the tool that is launched with Data Preview of a calculation view?
Choose the correct answer.
SAP Business Application Studio
SAP HANA Cloud Cockpit
SAP HANA Database Explorer
4.
Why do you hide columns in a calculation view?
Choose the correct answer.
When you want to hide a column that is used in a calculation but is not required to display in a report.
When you do not want to expose a sensitive column to a consuming calculation view.
To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.
When you want to hide some of a calculation view data based on attribute values.
5.
What is the role of the cube calculation view?
Choose the correct answer.
To aggregate measures without the need for dimensions
To project master data into a harmonized view
To develop a star schema for ad-hoc analysis
6.
What is the role of a dimension calculation view?
Choose the correct answer.
To aggregate measures by one or more attributes
To combine dimensions with a cube to form a star schema
To generate a view of master data from one or more tables
7.
Which are benefits of calculation views?
There are two correct answers.
They calculate live data on-the-fly
They can be defined using any database language
They adapt automatically to the requesting query
8.
Which is the default top-view node for a dimension calculation view?
Choose the correct answer.
Star Join
Projection
Aggregation