Skip to end of metadata
Go to start of metadata

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



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.


Default Aggregation in CDS

Simple CDS Query with Exception Aggregation AVG

Amount and Quantity Key Figures



  • No labels