3462487 - "Couldn't retrieve data from <QUERY_NAME>" error when trying to import data into a New Model type in SAP Analytics Cloud

Symptom

With the New Model type in SAP Analytics Cloud, import job with acquired ODATA connection, ends with the following error message: Couldn't retrieve data from <QUERY_NAME>
The same query can retrieve the data if using the Classic model.

Environment

SAP Analytics Cloud (Enterprise) 2024.2.8

Reproducing the Issue

Logon to SAP Analytics Cloud
Open the New Type Model
Try to create an import job
Notice that it will fail with the error message: Couldn't retrieve data from <QUERY_NAME>

Cause

There is a Decimal column, which is defined with a scale=variable. This can cause a problem in New Models and not Classic Models.

For OData V4 Variable Scale is not supported by SAC.

Resolution

The usage of "variable”" scale and an undefined precision for the decimal type property, in the OData service metadata can cause problems like the one being reported here.

The problem itself and solution for the same have been clearly explained in an SAP note we have prepared, 3462373 - Precision and scale decimal property types in Odata service in SAP Analytics Cloud (SAC) - SAP for Me.

Keywords

SAC, SAP Analytics Cloud, Model, New Type, Import, ODATA, "Couldn't retrieve data from", error, fail, not possible, could not. , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem

Product

SAP Analytics Cloud 1.0