We are facing issues with the Fiori List report generated using a CDS view with parameters and aggregations. The OData generated for CDS works perfectly fine. We created a Fiori List Report in Web IDE using this CDS view (with parameters and aggregations). The report does not produce any output at all. I
To further clarify we have the following types of CDS views in our system
- 1.CDS views with aggregations but no parameters – The Fiori list report generated worked as expected.
- 2.CDS views with parameters but no aggregations – The Fiori list report generated did not work immediately. We followed the steps mentioned in the blog and it worked well. https://blogs.sap.com/2018/06/11/sap-fiori-list-report-utilizing-parametrized-cds/
- 3.CDS views with parameters and aggregations – The Fiori list report generated did not produce any data instead throws the error as below. Note that the OData service for this CDS views works perfectly fine.
Has anyone tried creating Fiori list report using CDS view with aggregations and parameters? We do not want to use local annotations for these aggregations.