3691323 - Unexpected program error during data import using OData service connection in Sap Analytics Cloud (SAC)

Error encountered when importing data which falls into the range (-0.1, 0.1) excluding 0 for Edm.Decimal type into SAP Analytics Cloud using OData service connection: "unexpected program error".

SAP Analytics Cloud (Enterprise) 2025.21.6

1. Login to SAP Analytics Cloud.
2. Create a dataset using OData service connection.
3. Filter entity.
4. Drag the entire table to the query panel.
5. Click "Next".
6. Click "Create".
7. Observe the error: "unexpected program error".

Currently in SAC, it is unable unable to import the values in the range (-0.1, 0.1) excluding 0 for Edm.Decimal type whose precision and scale values are undefined in the OData service's $metadata. 

The two quickest solutions are:
- Define precision and scale for the Edm.Decimal in the OData service, if the data has values in the range mentioned above. This way the import would be successful.
- Or filter out the values in that range for now.

odata connection, sap analytics cloud, unexpected program error, data import error, odata service connection, dataset creation error, filter entity, query panel error, import data, sac , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem