SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 2

Provide reusable hierarchies for drilldown in a CUBE with star join

Access hierarchies created in external schemas

Provide reusable hierarchies for drilldown in a CUBE without star join

Enable SQL SELECT statements to access hierarchies

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

Union

Aggregation

Join

The hierarchy must be defined as a local hierarchy.

The hierarchy must be a shared hierarchy.

The hierarchy must be a parent-child hierarchy.

The hierarchy must be exposed by a CUBE calculation view with star join.

To provide a dynamic value in a calculated column

To break up complex SQL into smaller steps

To pass values between procedures and calculation views

To filter an attribute at run-time based on a user input

Input Parameter

Variable

Table function

Procedure

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.

''

<empty string>

'2'

'Null'

A measure that can only be displayed by those with necessary privileges

A measure that is filtered by one or more attribute values

A measure that can be consumed by a CUBE and not a DIMENSION

A measure that cannot be referenced by a calculated column