Symptom
When creating a model acquired from an SAP Business Warehouse (BW) datasource, you cannot get past the "SELECT Model DATA" dialog in SAP Analytics Cloud.
This error may also appear in the Chrome Developer Tools trace:
{"message":"Failed to call SAP Analytics Cloud agent. Please contact your administrator to ensure that SAP Analytics Cloud agent is running, is configured correctly, and is reachable from the SAP HANA Cloud Connector. HTTP Status: /service/api/epm/bw","stack":"","errorDetails":[{"messageId":"CALL_CLOUD_AGENT_SERVICE_FAILED_NEW","message":"Failed to call SAP Analytics Cloud agent. Please contact your administrator to ensure that SAP Analytics Cloud agent is running, is configured correctly, and is reachable from the SAP HANA Cloud Connector. HTTP Status: /service/api/epm/bw","bUIMessage":false,"bWarning":false}],"status":500,"bUIMsg":false,"bWarning":false}"
Environment
- SAP Analytics Cloud
- SAP Analytics Cloud Agent {"version":"1.0.65"}
Reproducing the Issue
- Connect to your SAP Analytics Cloud tenant.
- Create an Import connection to SAP Business Warehouse.
- Select "Create > Model" from the "Main Menu".
- Create an SAP Analytics Cloud query by selection your SAP Business Warehouse query and choosing Dimensions and Measures.
- Click "OK" on the "SELECT MODEL DATA" dialog.
- Notice that after processing for some time your are back at the "SELECT MODEL DATA" dialog.
Cause
The specific SAP Business Warehouse query you are accessing contains features that require the latest version of the SAP Analytics Cloud Agent.
Resolution
- Download the latest SAP Analytics Cloud Agent from https://launchpad.support.sap.com/#/softwarecenter/search/SAP%2520ANALYTICS%2520CLOUD%2520AGENT%25201.0
- Update your deployment to the new SAP Analytics Cloud agent as directed in the help: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/ecce365ed4cd40f2bf9fb7f9e5118436.html
See Also
- System Requirements and Technical Prerequisites
- SAP Analytics Cloud Support Matrix for Importing Data from SAP NetWeaver BW
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, BW, BW/4HANA, Agent, import, bex, query , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem