What are the requirements for an OData service when creating an Analytical List Page application?

[JWJ]

I am trying to create a Fiori Elements Analytical List Page in VS Code and after selecting my local schema.cds the dropdown for the "Main entity" selection is empty and the following text appears in red: "The OData V4 service you have provided is not suitable for use in an Analytical List Page application. The service must contain aggregate based entity sets for this floorplan."

Where do I find the requirements or examples for making a suitable service with "aggregate based entity sets"?

[JWJ]

I don't believe the answers so far helped. At least, I'm not sure how to implement the xml style tags into my Javascript style CDS files. I found info about adding a OData v2 proxy to run the app and then importing the metadata from that. Directly using the schema.cds fails in the Analytical List Page app generator. This way worked but it is a bit of a hassle.

[JWJ]

Adding a screenshot

[JWJ]

The screenshot won't display...

[EC]

Facing the same issue with a OData V4 service with RAP. I added the mandatory annotation in the cds but still no luck :§

[mhunzli]

Hi Jay Johnson,

did you get any help on your problem, or could you solve it? I just have the same problem. With OData V2 the ALP generation in BAS is working. But using OData V4 the same CDS-views it does not work.

[vinibar]

Your entity must be annotated with sap:semantics="aggregate" and its properties must be annotated with sap:aggregation-role="dimension" or sap:aggregation-role="measure". Here's some documentation on how to do that with CDS.

[MioYasutake]

Hi jayjohnson14,

The following blog explains how to build an analytical application on top of CAP.

Here you can find annotations to enable aggregation.

https://blogs.sap.com/2021/03/14/discovering-sap-fiori-elements-analytical-functions-by-implementing...

[JWJ]

That page is helpful but it doesn't mention this problem that I'm having with the app generator. I found that I need to use a OData v2 proxy to get it to work.