Preparing the Modeling Environment

Creating Calculation Views

Working with Common Nodes in Calculation Views

Joining Data Sources in Calculation Views

Working with Union Nodes in Calculation Views

Creating Data Slices

Ranking Data

Embedding Functions in Calculation Views

Creating Dynamic Calculation Views

Implementing Hierarchies in Calculation Views

Developing Custom Logic using SQL

Applying Best Practices for Modeling

Using Tools to Check Model Performance

Implementing Features to Improve Performance

Storing Calculation View Results

Using Additional Modeling Productivity Tools

Working in a Modeling Project

Managing the Lifecycle of a Modeling Project

Implementing Security in SAP HANA Modeling

Getting Started with SAP HANA Cloud Knowledge Graph Engine

Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

Why might you create an input parameter instead of a variable?

There are two correct answers.

To filter data by measures

To pass a dynamic value to an expression in a calculated column

To filter data by attributes

What must you do if you want to use the IP_COUNTRY input parameter value to filter the value help of the IP_CITY input parameter?

Choose the correct answer.

Create a value help view for the IP_COUNTRY parameter, listing countries with a filter on Country using an input parameter. Then map this input parameter to the IP_COUNTRY parameter.

Create a value help view for the IP_CITY parameter, listing cities with a filter on Country using an input parameter. Then map this input parameter to the IP_CITY parameter.

Create a value help view for the IP_CITY parameter, listing cities with a filter on Country using an input parameter. Then map this input parameter to the IP_COUNTRY parameter.

Create a value help view for the IP_COUNTRY parameter, listing countries with a filter on Country using an input parameter. Then map this input parameter to the IP_CITY parameter.

Variables can be defined on attributes and measures - true or false?

Choose the correct answer.

True

False