Skip to Content
1
Former Member
May 07, 2018 at 09:31 AM

Unsupported DefaultAggregation: #AVG in analytical CDS

1311 Views

Hello,

The requirement is to provide Average aggregation for a measure in Fiori app (with dynamic sorting and filtering).

Average is not supported as Default Aggregation in CDS when claiming @Analytics.dataCategory: #CUBE.

As an alternative I've tried to use Exception Aggregation with @Analytics.query: true. The problem is that join or association with sub-CDS (which is required in my case) is not enabled for "@Analytics.query: true" annotation ("Error reading InfoProvider for CDS view..").

Any advices on how the AVG aggregation should be implemented in Fiori app reading from Hana CDS?

Regards,
Lena