You create an SAP HANA HDI Calculation View.

When creating an SAP HANA HDI Calculation View, choosing thedata category Cube with Star JoinoverDimensiondepends on the specific requirements of your data model. Below is a detailed explanation of why the verified answers are correct.

Data Category Dimension:

Used for modeling master data or reference data.

Does not support measures or aggregations.

Typically used for descriptive attributes (e.g., customer names, product descriptions).

Data Category Cube with Star Join:

Used for modeling transactional data with measures and dimensions.

Supports star schema designs, combining fact tables (measures) and dimension tables (attributes).

Enables advanced features like aggregations, time characteristics, and joins between master and transactional data.

Star Join:

A star join connects a fact table (containing measures) with dimension tables (containing attributes) in a star schema.

It is optimized for performance and scalability in analytical queries.

Key Concepts:

Option A: You can combine master data transactional data.

Why Correct?The Cube with Star Join data category is specifically designed to combine transactional data (fact tables) with master data (dimension tables).This enables comprehensive reporting and analysis.

Option B: You can persist transactional data.

Why Incorrect?Persisting transactional data is not a feature of the Cube with Star Join data category. Persistence is typically handled at the database or application layer.

Option C: You can provide default time characteristics.

Why Correct?The Cube with Star Join data category supports default time characteristics (e.g., fiscal year, calendar year), which are essential for time-based reporting and analysis.

Option D: You can create restricted columns.

Why Incorrect?Restricted columns are a feature of calculation views but are not specific to the Cube with Star Join data category.They can also be created in Dimension views.

Option E: You can aggregate measures as a sum.

Why Correct?The Cube with Star Join data category supports aggregations, such as summing measures.This is a key feature for analyzing transactional data.

Verified Answer Explanation:

SAP HANA Modeling Guide:The guide explains the differences between data categories like Dimension and Cube with Star Join, highlighting their respective use cases.

SAP Note 2700850:This note provides examples of scenarios where Cube with Star Join is preferred over Dimension, emphasizing its ability to handle transactional data and aggregations.

SAP Best Practices for HANA Modeling:SAP recommends using Cube with Star Join for analytical models that require combining master and transactional data, providing default time characteristics, and performing aggregations.