This page refers to CDS views: HowTo use in BW contexts, see 'Value Help for Variables/Parameters'.
When a DCL-0 dimension view has a value help view defined with annotation @Consumption.valueHelpDefinition, this value help view will be used in both variable screen and query result.
When a DCL-0 dimension view has no value help view defined: in variable screen F4 gets no value; in query result, F4 shows the value list authorized by the cube view with Q mode.
Here is a Dimension View with a value help view defined:
Dimension View
@AbapCatalog.sqlViewName: 'ZGLPLANETYPEV'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.representativeKey: 'planetype'
@Consumption.valueHelpDefinition: [{entity.name: 'ZGLPLANETYPE_VH' }]
@EndUserText.label: 'ZGLPLANETYPE'
define view ZGLPLANETYPE as select from saplane {
key planetype as PlaneType,
seatsmax as MaxSeats,
@DefaultAggregation: #MAX
op_speed as Speed
}
Value Help View
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'value help for zglplanetype'
@AbapCatalog.sqlViewName: 'ZGLPLANETYPEVH'
@Analytics: { dataCategory: #DIMENSION }
@ObjectModel.representativeKey: 'PlaneType'
define view ZGLPLANETYPE_VH as select from saplane {
key planetype as PlaneType,
}
where seatsmax > 300