A field F in a CUBE CDS view can be associated to a master data CDS view (with annotation @Analytics.dataCategory: #DIMENSION) so that this element will get additional attributes.
- Master data association (annotation @ObjectModel.foreignKey.association) can be time dependent so that the element gets time dependent attributes
- The time independent master data CDS view should contain unique values. That is, there is no duplicated records for the same master data value.
- The time dependent master data CDS view should contain unique value for any given time spot. That is, there is no duplicated records for the same master data value for any given time..
If point 2 or 3 are broken, a query build on CDS model may get unexpected key figure multiplication when drill down some attributes. The reason is similar to the effects explained in Ambiguous Join.
Unique master data is a fundamental pre-requisite for CDS modeling