BW InfoObjects modeled by CDS Views
Similar to BW, InfoObject in CDS could be:
- Key figures / measures:
Fields defined with annotation @DefaultAggregation: #SUM, #MIN or #MAX or @Aggregation.default: #SUM, #MIN, #MAX or #NOP,.
Usually they are directly defined in a "@Analytics.dataCategory: #CUBE" CDS views.
If it is defined in a "@Analytics.dataCategory: #DIMENSION" CDS views, it is a key figure attribute of the InfoObject.
By using @Aggregation.default: #NOP, key figure can have default aggregation NO2. - Characteristics:
All other fields, either without any @DefaultAggregation/@Aggregation.default annotation, or with @DefaultAggregation:#NONE.
If the data type of the field is a key figure type, such as CURR, QUAN, DEC, FLTP..., it is not supported for a characteristic. In this case, the field is simply ignored before Note 2771186 and 2778887. After this note, the field gets a default NO2 aggregation and becomes a NO2 key figure. Explicit set @Aggregation.default:#NOP is not recommended as it is not supported in SADL service.Thus please just remove the @DefaultAggregation/@Aggregation.default annotation.
Long timestamp (data type TIMESTAMPL) field is not supported. The field is ignored. (Note 2737769, 2887459 )
Fields longer than 250 characters are only considered up to the first 250 charaters. See Note 2852065.
SAP Online Documentation
DefaultAggregation Annotations
Characteristics
Features:
- Compounding in CDS
- Time characteristics
- Value help
- Language dependent Labels
- Reference characteristics
Key Figures
- Only support default aggregation: SUM, MIN, MAX, NOP.
- To use other aggregation such as AVG, please use formula exception aggregation in a CDS query.
- Semantics needs to be defined for amount or quantity key figures
- In a CDS query, key figure can't be used in CASE statement when clause as a condition. Because filtering on a key figure is not supported in Analytic Engine. Please use a formula with IF clause instead.
- In a dimension CDS view ( with annotation @Analytics.dataCategory: #DIMENSION), no key figure fields can be defined as key fields. Only characteristic fields can be key fields.
Examples:
Simple CDS Query with Exception Aggregation AVG
Amount and Quantity Key Figures