SAP Knowledge Base Article - Public

3746273 - ALP cannot consume Datasphere Analytical Model OData in Business Application Studio

Symptom

When testing an SAP Datasphere Analytical Model OData API in SAP Business Application Studio (BAS), the following error is returned:

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.

Environment

- SAP Datasphere (all versions)
- SAP Business Application Studio (all versions)

Reproducing the Issue

  1. Open SAP Business Application Studio.
  2. Create or open an Analytical List Page (ALP) Fiori elements application project.
  3. When prompted, provide the SAP Datasphere Analytical Model OData V4 service URL as the data source.
  4. Attempt to use or preview the service.
  5. Observe the error: The OData V4 service you have provided is not suitable for use in analytical list page application.

Cause

SAP Datasphere Analytical Model consumption APIs use an OLAP processing approach: data is automatically aggregated based on the dimensions and measures specified in the $SELECT query parameter. The $METADATA semantics of these APIs do not support the $APPLY aggregation parameter, which is mandatory for Fiori elements Analytical List Page (ALP) templates. As a result, ALP cannot consume SAP Datasphere Analytical Model OData APIs directly.

Resolution

As an alternative, use SAP Datasphere OData APIs exposed from Graphical Views or SQL Views configured for consumption (relational approach). These views are executed with the standard SQL engine and support group-by aggregations via the $APPLY parameter and $COUNT for identifying the total number of records.

To request support for the $APPLY parameter in SAP Datasphere Analytic Model consumption APIs, submit an enhancement request via the SAP Influence Portal. Refer to KBA 3332382 - How to create an enhancement request for SAP Datasphere? for instructions.

Note: SAP Datasphere Analytic Model consumption APIs do not currently support the $APPLY parameter. This limitation has been reported to SAP Datasphere product management.

See Also

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

Keywords

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

Product

SAP Datasphere all versions