Calculation View Dimension KEY Column

[aharon_digilov2]

Hi

Need help to understand what purpose of KEY ?

When I'm creating Calculation View Dimension and going to the Semantics --> Columns

The second column is KEY check box.

I checked all SAP Guides but can't found any reference for this setting.

There a lot of  documentation regarding Attribute View's KEYs , but no word regarding Calculation View.

Anyone know why a should define (or not) Column as Key in Calculation View Dimension ?

Thanks

[SergioG_TX · Accepted solution]

Aharon,

when you have a view, you can add a KEY to uniquely identify a record in the records set faster than if you were just to scan the entire view for such record.

When a KEY is added to a table (not in a view but the table itself) it enforces a way to avoid duplicate records to be inserted into the table. it also allows for a faster scan of the records on the columnar table.

further, the key is also used if you were to expose this view via an xsodata service. if the view doesnt contain a key, then you can generate one dynamically only when on the xsodata service.

maybe others can add more to this simple explanation

[anindya_bose]

Calculation View type Dimension is successor of Attribute View.  Reason to keep Key is same as that for Attribute View .

Regards

Anindya