Symptom
When creating a query for import model based on Datasphere connection with Odata in SAC, getting following errors:
- Couldn't create <Query_name> job
- 'The freehand query is not an entity set or function import'
- The following error message comes from the external data service: status: 400 body: {"status":400,"message":"Bad request; please refer to documentation"}"'
Environment
SAP ANALYTICS CLOUD 2024.2.8
Connection: Import
Datasource: Datasphere using OData services
Reproducing the Issue
- Login to SAC
- Go to Modeler
- Create new import model with data
- Select the data-source as OData services
- Select the connection
- Provide a query name
- Select Freehand query
- Type the freehand query and click next
- Notice that query failed to create with the error: 'The freehand query is not an entity set or function import'.
Cause
This issue is under investigation by the development team.
Resolution
This issue is under investigation by the development team.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 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?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
-
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- 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!
Keywords
OData, datasphere, connection, query, model, import connection, modeler, parameters, SAC, DWC , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem
Product
SAP Analytics Cloud all versions