You need to defne an SAP HANA calculation view watt numbers that represent codes instead Of aggregated values Which Settings should you choose? (1)

Question

Options

• AChoose the DIMENSION data category and use the numbers as attributes
• BChoose the DIMENSION data category and use the numbers as measures
• CChoose the CUBE data category and use the numbers as measures
• DChoose the CUBE data category and use the number as attributes

• A
  93% (55)
• B
  2% (1)
• C
  2% (1)
• D
  3% (2)

Explanation

Option A is correct because when numbers represent codes (e.g., country codes, status codes), they are descriptive identifiers - not values to be summed or aggregated - making the DIMENSION data category the right choice, and those numbers should be defined as attributes (descriptive characteristics), not measures.

Option B is wrong because even though DIMENSION is correct, measures imply aggregation (sum, count, average), which is meaningless for a code like "001" or "42" used as an identifier.

Options C and D are both wrong because the CUBE data category is designed for fact/transactional data that requires aggregation - it is the wrong category for master/reference data like codes, regardless of whether you use measures or attributes.

Memory tip: Think "DIMENSION = Descriptive" - codes describe something, so they belong in a DIMENSION view as attributes. CUBE is for Calculated/aggregated numbers you actually do math on.

No community discussion yet for this question.