You want to define a restricted column in an SAP HANA calculation view. What do you need to define?(2)

Question

Options

• AA condition criteria
• BAn SAP HANA data type
• CAn aggregation method
• DA referente to an existing measure

• A
  90% (38)
• B
  7% (3)
• C
  2% (1)

Explanation

A restricted column in an SAP HANA calculation view is essentially a filtered copy of an existing measure - it applies a condition to limit which records contribute to the aggregation. You must reference an existing measure (D) because the restricted column derives its values and aggregation behavior from it, and you must define a condition/filter criteria (A) that specifies the restriction (e.g., "only include rows where Region = 'EMEA'").

Why B is wrong: You don't manually assign an SAP HANA data type - the restricted column inherits the data type from the source measure automatically.

Why C is wrong: The aggregation method is not defined on the restricted column itself; it's inherited from the referenced measure. You're restricting what gets aggregated, not how it's aggregated.

Memory tip: Think of a restricted column as a "WHERE clause wrapped around a measure" - you always need the measure to filter (D) and the filter condition itself (A), just like a SQL expression needs both a column and a WHERE clause.

No community discussion yet for this question.