You want to attivate an SAP HANA calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement a measure does not make sense. Besides changing the…

Question

Options

• ASwitch from an aggregation node to a star join node
• BSwitch from a projection node to an aggregation node
• CSwitch from an aggregation node to a projection node
• DSwitch from an aggregation node to a rank node

• A
  4% (1)
• B
  4% (1)
• C
  86% (24)
• D
  7% (2)

Explanation

Switching from an aggregation node to a projection node (C) is required because aggregation nodes inherently demand at least one measure to perform their aggregation logic - removing this node eliminates the "no measure defined" constraint. Together with changing the category to DIMENSION, this fully resolves the error since DIMENSION views use projection nodes to pass through attribute data without any aggregation.

Why the distractors fail:

• A (star join node) is used for combining fact and dimension views in a star schema and does not address the missing-measure error.
• B is the opposite of what's needed - adding an aggregation node would introduce or preserve the measure requirement, making the problem worse.
• D (rank node) is a specialized node for ordering/ranking rows and has no bearing on the measure requirement.

Memory tip: Link node type to data category - CUBE → Aggregation node (needs measures), DIMENSION → Projection node (just passes attributes through). If you drop the CUBE category, you must also drop the aggregation node that enforces it.

No community discussion yet for this question.