Symptom
The query name used in the import job is not the actual query in the data source, e.g. in the following screenshot, "SAC_QUERYQuery" is the query name used inside SAC, not the actual query name in data source:
How to check the query information used in the import job of a model in SAC?
Environment
- SAP Analytics Cloud (Enterprise)
Resolution
The query information can be found by following below steps, the data source used in the example is the SAP internal test data source from HANA database:
- Go to Data Management work space in the model.
- Select the import job.
- Open the Chrome or Edge Browser Developer Tools from the menu (under Settings and more (...) > More tools > Developer tools) or by pressing Ctrl + Shift + I (or the F12 function key).
- Switch to the network tab in the Developer Tools window.
- Click the Edit Query option in SAC.
- Select the entry in network tab of Chrome developer tool, of which request URL is "https://<SAC host>/sap/fpa/services/rest/fpa/dataAcquisition/v1/queries/<query ID>?&tenant=1&_=<Epoch Timestamp in millisecond>"
- Click Preview or Response, the query information can be found like query name, variables and selected objects:
{
"queryId": "<query ID>",
"name": "SAC_QUERYQuery",
"definition": "{\"queryInfo\":{\"name\":\"SAC_QUERY\",\"objectType\":\"ENTITY\",\"columnObject\":\"\\\"_SYS_BIC\\\".\\\"efashion/SAC_QUERY\\\"\",\"catalogName\":\"efashion\",\"cubeName\":\"SAC_QUERY\",\"cubeDescription\":\"CV_SALES\",\"viewType\":\"CalculationView\",\"variables\":{\"City\":[{\"function\":\"EQUAL\",\"arguments\":[\"Los Angeles\"],\"useBackendDefault\":false,\"attribute\":\"CITY\"}]},\"prompts\":{},\"columns\":[\"CITY\",\"QUANTITY_SOLD\",\"YR\"],\"filters\":{\"treeOperator\":\"AND\",\"operands\":[],\"nodeId\":2,\"version\":1}}}",
"connectionId": "<connection ID>",
"createTime": "<create time>"
}
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- 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?
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
query, SAC, how to, source query , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
Attachments
Pasted image.png |