3746273 - Business Application Studio's (BAS) Analytical List Page (ALP) is unable to consume Datasphere Analytical Model's OData

Upon testing DS OData API in BAS you face the message:

The OData V4 service you have provided is not suitable for use in analytical list page application.
The service must contain aggregate-based entities for this template.

SAP Datasphere
BAS

Try to consume DS OData API in BAS.

Currently the SAP Datasphere Consumption APIs for Analytic Models (analytical fashion - OLAP processing) is not support by the Fiori elements of ALP. The reason for that is analytic models automatically aggregate the data depending on the dimensions and measures selected in the $SELECT query param and the $METADATA semantics - not supporting the $APPLY for aggregation, which is mandatory for ALP Fiori elements.

As a possibility for supporting ALP with SAP Datasphere APIs, it is possible to use any OData APIs with Graphical or SQL Views exposed for consumption (relational fashion). The views are executed with the standard SQL engine with support group by aggregations via the $APPLY parameter, and $COUNT for identifying the total number of records in the view.

This is currently not planned for the SAP Datasphere Analytic Model consumption APIs to support the $APPLY parameter. This limitation has already been raised to the SAP Datasphere product management and the recommendation is to create a request in the Influence Portal  for this topic get more visibility and priority.

SAP KBA - 3332382 - How to create an enhancement request for SAP Datasphere?

metadata, annotation, V1, V2, V4 , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Problem