SAP Knowledge Base Article - Public

2522791 - "SELECT MODEL DATA" dialog hangs when creating a model acquired from an SAP Business Warehouse (BW) datasource in SAP Analytics Cloud

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

  1. Connect to your SAP Analytics Cloud tenant.
  2. Create an Import connection to SAP Business Warehouse.
  3. Select "Create > Model" from the "Main Menu".
  4. Create an SAP Analytics Cloud query by selection your SAP Business Warehouse query and choosing Dimensions and Measures.
  5. Click "OK" on the "SELECT MODEL DATA" dialog.
  6. 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

  1. Download the latest SAP Analytics Cloud Agent from https://launchpad.support.sap.com/#/softwarecenter/search/SAP%2520ANALYTICS%2520CLOUD%2520AGENT%25201.0
  2. 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

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

Product

SAP Analytics Cloud 1.0