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