Besides changing the data category to DIMENSION, what do you have to do?

You want to build an SAP HANA HDI 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 data category to DIMENSION, what do you have to do?
A . Switch from an aggregation node to a star join node
B. Switch from an aggregation node to a projection node
C. Switch form a projection node to an aggregation node
D. Switch from a projection node to a star join node

View Answer

Answer: B

Explanation:

In SAP HANA HDI Calculation views, if you’re creating a cube and there are no measures defined (which is mandatory for cubes), and you don’t want to switch to the Dimension data category, you can switch from an aggregation node (which requires at least one measure) to a projection node. A projection node doesn’t require a measure, so this will resolve the "no measure defined" error.