cancel
Showing results for 
Search instead for 
Did you mean: 

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

monsuban
Explorer
0 Kudos

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
Advisor
Advisor
0 Kudos
Hi, Would you please use this annotation in CDS query view(@Analytics.query: true)?
View Entire Topic
monsuban
Explorer
0 Kudos

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.