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.
See Also
- 3462373 - Precision and scale decimal property types in Odata service in SAP Analytics Cloud (SAC) - SAP for Me
- 3066127 - "The import has encountered an error. Try Again" with New Model Data Import option - SAP for Me
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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