You create an SAP HANA HDI Calculation View in SAP Web IDE for SAP HANA and have to select a data category which data category allows you to create restricted columns? Note: There are 2 correct…

Question

Options

• ACube with Star Join
• BDimension
• CSQL Access Only
• DCube without Star Join

• A
  79% (30)
• B
  13% (5)
• C
  8% (3)

Explanation

In SAP HANA Calculation Views, restricted columns are measure variants that apply a fixed filter condition to limit which data contributes to a measure's aggregation - and this capability is only available in Cube data categories. Both Cube with Star Join (A) and Cube without Star Join (D) support restricted columns because they are designed for fact/measure-based analytics where such restrictions are meaningful.

Dimension (B) is wrong because dimension views contain attributes/master data, not measures - restricted columns have no purpose without measures. SQL Access Only (C) is wrong because it strips away OLAP/analytical modeling features entirely, leaving only raw SQL access with no support for advanced column types like restricted or calculated columns.

Memory tip: Think "Restricted columns Require measures → only Cubes." If the data category isn't a Cube variant, it can't host restricted columns. The Star Join distinction is irrelevant to this feature - both Cube types qualify.

No community discussion yet for this question.