Fiori List report using CDS view with parameters and aggregation

[Sharadha1]

Hi all,

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.

[peter_melouney]

Hi Sharadha,

I just encountered the same issue. Did you manage to get it working?

Cheers,

Pete

[azmathshaikh]

In manifest.json,

1. change the enitity set name and append Results.

2. Also add "considerAnalyticalParameters" to manifest.json

[former_member803052]

@azmathshaikh Thanks. This worked for me. But it error out when i add intent navigation to my List report. Any options to overcome this issue is highly appreciated. Thanks.