Symptom
- Technical ID of the BW query used in setting up of SAC import job is visible only at the time of setting up the import job and post that it is not possible to check anywhere in the SAC system that from which backend BW query the import job is fetching data.
- How to know which backend query is fetching data while doing import jobs?
- Is there a way to check technical ID of the query in place of query name in SAC?
Environment
SAP Analytics Cloud version: 2.0
Datasource: import BW
Reproducing the Issue
- Log in to SAC.
- Go to modeler.
- Open the model.
- Switch to data management.
- In query section there is the query description and not the technical ID of the exact query used.
Resolution
-
There is no way to find the technical ID of the BW query in SAC. We request you to raise an enhancement request to surface the technical ID in the SAC UI : 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? - SAP for Me
-
Workaround :
But one can still find the technical ID by inspecting the browser network traffic.When you open the "Data Management" workspace of a model, one of the browser request is named "search?tenant=...", going to URL /sap/fpa/services/rest/fpa/dataAcquisition/v1/queries/search?tenant=... . If there are BW queries used in the mode, that request's response would contain the technical names of all those BW queries, in the respective "definition" properties.
See Also
- 3220729 - Checkpoints: Import and Export Job for SAP Analytics Cloud (SAC) Data to BW or BW/4HANA via an OData Service - SAP for Me
- 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://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- 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
SAC, Import job, query, BW query, technical name. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem