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
- Logon to SAP Analytics Cloud.
- Create a Model from a SalesForce "User Predefined Model".
- 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
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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