SAP Knowledge Base Article - Public

3463001 - Analytical model of datasphere with input parameter is not visible when working with OData connection in SAP Analytics Cloud (SAC).

Symptom

Measures and dimensions are missing in the query builder in SAC when creating model on OData connection to Datasphere.

Environment

  • SAP Analytics Cloud version 2024.2.18
  • OData connection

Reproducing the Issue

  1. Login to SAC.
  2. Under side navigation go to Modeler. 
  3. Select Connection as OData services.
  4. Choose connection name.
  5. Select query and click on Next.

Notice that only one measure is available under query builder. Although other measures and dimensions are there in Datasphere side. 

Cause

Input parameter is not supported in SAC Query Builder.

Resolution

Set the default value for the input parameters on DS side. Then in SAC, use freehand query instead of the query designer to fetch the data.

See Also

Keywords

model, OData, import, measure, dimension, query , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0