A field F in a Cube CDS view (with annotation @Analytics.dataCategory: #CUBE) can be associated to a Dimension View (a master data view with annotation @Analytics.dataCategory: #DIMENSION):
- Foreign key association (annotation @ObjectModel.foreignKey.association) should be defined to a master data CDS view with the representative key field of the same length or a longer length than field F's length. Otherwise, unexpected query result may occur.
- All the values in field F should all exist in the Dimension View. Otherwise unexpected query result may occur when hierarchy is active. F4 may get less values, text or display attribute may not available for some key values.
- 2835242 - More Values in Cube CDS View than in Dimension View