Modeling functions

Question 1

A “Restricted” column means?

Answer 1

It means the result column is restricted to an attribute value. So it could be restricted to Country or restricted to Country = US

Question 2

Where can restricted columns be created?

Answer 2

In aggregation and Star join nodes af a calculation

Question 3

Does HANA modeling support SQL

Answer 3

Only a limited list of SQL functions

Question 4

What are the first steps in using the column calculation wizard?

Answer 4

Choose the column type, measure or attribute

Question 5

What 2 choices exist for the expression of calculated columns?

Answer 5

SQL or the Column Engine

Question 6

Which process offers better optimization. SQL or SQL script?

Answer 6

SQL

Question 7

What calculation node views can contain a filter

Answer 7

Projection
Union
Join
Rank
Aggregation
Star Join

Question 8

Where are variables defined?

Answer 8

In the semantics of the calculation view

Question 9

What are the parameter mapping types

Answer 9

Data sources
Procedures/Scalar functions
Views for value help for parameters
Views for value help for attributes

Question 10

What are the three node styles

Answer 10

Level name  (level and node name)
Level path    (node name and ancestors)
Name only   (node name)

Question 11

What object adds a where clause to a query?

Answer 11

A variable (not an input parameter)