exception aggregation used in CDS view and that field is not available in SAC

[monsuban]

Hi Experts,

I have used exception aggregation in the CDS consumption view like:

@AnalyticsDetails.query.axis: #COLUMNS

@EndUserText.label: 'Total Accounts in SAP'

@AnalyticsDetails.exceptionAggregationSteps.exceptionAggregationBehavior: #MAX

@AnalyticsDetails.exceptionAggregationSteps.exceptionAggregationElements: [ 'portion' ,'CompanyCode' ,'UtilitiesDivision']

TotalAcctsSAP,

This field is not available in SAC to be consumed. Not available in the model as well.

 Can anyone help me on this..

Thanks,

Subhankar Mondal

[sheldon_piao]

Hi, Would you please use this annotation in CDS query view(@Analytics.query: true)?

[monsuban]

That is being used already as the CDS is being consumed from SAC. Issue is only with one field where the exception aggregation is being used ; other fields are available in  SAC but that particular field.