Question Re: ABAP CDS view: use @DefaultAggregation: #FORMULA without @Analytics.query: true in Technology Q&A

ABAP CDS view: use @DefaultAggregation: #FORMULA without @Analytics.query: true

Former Member — Thu, 19 Jul 2018 15:15:59 GMT

Dears,

I would like to create a consumption or composite ABAP CDS view with calculations that behave as a formula i.e. has to be calculated after the operands have been determined by aggregation or calculation. It should never be aggregated. Later on the front-end (BW or CDS query) the result of the calculations should change according the characteristics selected by the user (this is possible with Calc view calculated columns)

The problem is that calculation on CDS views by default are done at records level and aggregated, hence my idea was to use the @DefaultAggregation: #FORMULA annotation to get the desire result. However I only managed to make it work for abap cds queries (@Analytics.query: true), while for other CDS views, I got the "Element contains unsupported aggregation #FORMULA [Analytics]" error.

is this annotation supported by other types of ABAP CDS view? I would like to make those calculations before the queries.

Regards,

Antonio

Re: ABAP CDS view: use @DefaultAggregation: #FORMULA without @Analytics.query: true

sreehari_vpillai — Sun, 09 Dec 2018 06:48:02 GMT

did you find any solution ? I also have the same issue.

Sreehari

Re: ABAP CDS view: use @DefaultAggregation: #FORMULA without @Analytics.query: true

leogannon — Fri, 14 Dec 2018 11:52:11 GMT

I found a resolution to this (just in case anyone is still looking for one)

if you use the annotation @AnalyticsDetails.query.formula you can enter an expression

e.g.:

    @Aggregation.default: #FORMULA
    @AnalyticsDetails.query.formula: 'NDIV0(OrderDelivery.Volume / OrderDelivery.OrderCountDec ) * 100'
    @AnalyticsDetails.query.decimals: 2
    1                           as Percentage

I hope this helps as I spent a while searching for a resolution to this and all I found was this unanswered post.

Leo