Symptom
When you try to copy a planning model, the following error occurs in SAP Analytics Cloud for Planning (SAC):
- The Model (Planning) could not be copied.
This issue happens with some models only.
Even the model owner cannot copy the model.
In F12 -> network, you see one request with status 500. In the response part, the following message is shown:
- {"message":"dberror(PreparedStatement.executeBatch): 274 - inserted value too large for column: Failed in \"MESSAGE\" column with the value '[CID:9eef7f2d-9f7f-40c6-b819-c76e0a69a732] The dimension is used as the currency dimension of a model. Therefore in the following members, a currency is required: <member 1>, <member 2>, ...'","bUIMessage":false,"bWarning":false}],"status":500,"bUIMsg":false,"bWarning":false}
Environment
- SAP Analytics Cloud (Enterprise) 2020.14.29
Cause
This model is using a dimension as the Dimension with Currency Property enabled. However, some of its members do not have a currency maintained.
Resolution
Maintain currency for all members of the dimension with currency property enabled.
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 case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem