Multiple blocks can be defined only within a single calculation view.

The block must have only one start node.

The block must start with a node that defines a table as a data source.

Only one block can be defined across a stack of calculation views.

To increase the possibilities for consumption

To fine-tune performance

To implement custom functions

To define dynamic analytic privileges

A project

An src folder

A space

A database module

Define constant values.

Reference the output of a procedure.

Assign a hierarchy node.

Map columns from lower nodes.

Create and map an input parameter.

Procedure

Scalar function

Anonymous block

Table function

Batch Task

Procedure

Function

Real-time Task

Replication Task

To ensure semantic correctness

To avoid duplicate rows in the output

To force filters to apply at the lowest node

To hide columns that are not required

Projection

Aggregate

Case

Pivot

Use an aggregation node.

Use a union node.

Use an intersect node.

Use a minus node.

To reduce flowgraph maintenance

To access additional node types

To improve flowgraph performance

To start multiple flowgraphs at the same time

To establish a connection to the replication service

To be notified when remote data has changed

To update data in a local table based on changes made to a remote table

To assign a virtual table to a remote source

Avoid union pruning.

Partition large tables.

Limit the number of stacked calculation views.

Aggregate data early in the data flow.

The Country column is requested.

Join cardinality is set: 1.

The Keep flag is activated for the Customer column.

Integrity constraint is set to RIGHT.

To prevent filtered columns from producing incorrect aggregation results.

To improve filter performance in join node

To allow filter push-down in stacked calculation views

To ignore a filter applied to a hidden column

The credentials clause defines TYPE 'PASSWORD' but does not specify a technical user

The remote system is not reached through the company network

You do not have the CREATE REMOTE SOURCE privilege on the remote system

The specified adapter is not registered with your SAP HANA system

The names of the input parameters do not match.

You selected the wrong parameter mapping TYPE.

Your source calculation view is of type DIMENSION.

You already mapped the input parameters in another calculation view.

A is successful.

•Fails.

A fails.

•B is successful.

A fails.

•B fails.

A is successful.

•B is successful.

Results are read from static cache.

Count-distinct results are incorrect.

SQL compilation time increases.

Query processing time improves.

To check the results without applying user privileges.

To test your code without generating a logic container.

To hide the actual tables by using aliases in the code.

To execute a statement without creating entries in the database log.

Table function

Procedure

Row table

Scalar function

An organization hierarchy that provides role-based access to data.

A scalar function that returns a list of the allowed values for each attribute.

A table function that returns a list of allowed values.

A procedure that returns the data access condition as an SQL expression.