SAP Knowledge Base Article - Public

2567448 - Models cannot be created using "User Predefined Model" from SalesForce connection in SAP Analytics Cloud

Symptom

Models cannot be created using "User Predefined Model" from Salesforce connection in SAP Analytics Cloud.

  • "Model was not created. An error occurred."
    • In Google Developer Tool (F12) Network tab there is a Request with status code "400 Bad Request"
    • Response in the same request: 
      {"errorMessage":"<SFDC Measure> of dimension t.8:<SAC Model Name>_Measures has conflicting values (both <AggregationA> and <AggregationB>) for property _DESCRIPTION.","errorStatus":400}

  • "Data import from model failed. Please try Data Refresh or Scheduling."
    • In Google Developer Tool (F12) Network tab there is a Request with status code "400 Bad Request"
    • Response in the same request: 
      {"errorMessage":"An internal error has occurred: Data access extension request at /data/data[0]/fromDAEDataTable failed with code <code> and message [Simba][SimbaSalesforceDAE]<code>) Content of table source <Predefined Model name> could not be found. Check permissions or run the report and try again. .","errorStatus":400}

Environment

  • SAP Analytics Cloud 2017.22.6
  • SalesForce

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Create a Model from a SalesForce "User Predefined Model".
  3. Notice one of the errors mentioned in the Symptom part.

Cause

  • The predefined Model has a measure which is an aggregation of amount and currency.
    • One measure cannot use different currencies, as different currencies cannot be summed. 
    • In case of all values are using the same currency, it has no sense to create an aggregation. 

Resolution

  • The behavior is by design.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, select, data, define, query, available, member, select, SFDC, SF, string , 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