What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension?

You create an SAP HANA HDI Calculation View.

What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.
A . Create restricted columns
B. Provide default time characteristics
C. Persist transactional data
D. Combine master data and transactional data
E. Aggregate measures as a sum

View Answer

Answer: B,D,E

Explanation:

Creating restricted columns isn’t a specific reason to choose Cube with Star Join. Restricted columns can also be created in other data categories.

When choosing Cube with Star Join, you are provided with default time characteristics. This makes the Cube with Star Join particularly useful for time-dependent data analysis.

Persisting transactional data is a process of database operations, not specifically related to the choice between Cube with Star Join or Dimension.

Cube with Star Join combines master data and transactional data. The master data is typically stored in the dimensions of the star schema, and the transactional data is stored in the fact table at the center of the star schema.

Cube with Star Join can aggregate measures as a sum, which is important for analysis in many business scenarios.