Symptom
As there is no Standard Import Connection to Datasphere, customers need to use OData Services connection in order to import data from Datasphere for planning purposes.
There is a question about availability of Datasphere views/datasets when establishing an OData services connection in SAC: Is it possible to consume different views/datasets from DS using only one OData connection in SAC?
- The Service URL required to establish the connection provides access only to specified view exported through the URL.
- Customers may look for a generic URL which will grant access to all the view/datasets inside a particular space.
Environment
SAP Analytics Cloud 2023.21.16
Reproducing the Issue
- Create an OData Services connection pointing to Datasphere view/dataset (Import Data Connection to OData Services | SAP Help Portal)
- Go to create a model based on this connection
- Note that you are not able to consume other DS views/datasets different from specified one in SAC connection
Cause
This is an expected behavior accordingly to how OData Services connection work.
Resolution
There are 2 ways to consume data from Datasphere:
- Live Data Connections to SAP Datasphere | SAP Help Portal
- Import Data Connection to OData Services | SAP Help Portal
Method 1 allows you to see all available models while method 2 just allows you just accessing data from specified OData Service.
At this moment, there is no option to establish an Import Connection to Datasphere and see all models from there. You need to use Live Connection for this purpose.
As a way to continue improving the application, SAC team provides a way for customers to create Enhancement Requests. There you can add your idea/desire of having an Import connection to Datasphere that allows seeing all available services.
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 incident for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.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 > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting 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, Datasphere, Import Connection, OData Services, views, see all , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To