Symptom
- An issue arises when attempting to add a custom order to a table in a Story in SAC.
- The error message presented as soon as the custom order panel loads is: "A custom order cannot be created because of the following issue: {\"_isUnitConversionMeasure\":false,\"sourceUnit\":\"XXX\",\"targetUnit\":\"XXX\",\"date\":\"XX.XX.XXXX\",\"technicalMeasure\":\"XXXX\",\"failingVersionType\":\"XXXX\",\"conversionMeasure\":\"XXXX\",\"querySource\":\"/t.B.MODELID/MODELID\",\"isMDSConversion\":false,\"measureSettings\":{},\"datasetId\":\"planning:[TENANT_B][][/t.B.t.B.MODELID/MODELID]\"}"
Environment
SAP Analytics Cloud
Reproducing the Issue
- Access the Story to be modified
- Select the row header, and click on the "Add custom order…" option
- The error is presented as soon as the custom order panel loads
Cause
The issue is due to the incorrect currency conversions.
Resolution
Add the missing currency rate in currency table -> conversion error -> Analyze.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 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 a case for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- 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 Analytics Cloud, SAC, custom order, table, error, issue, conversion, currency, rate, table, order, error, validation , KBA , LOD-ANA-TAB-SOR , Table Sort, Ranking, Member Sort, Value sort, Custom Sort , Problem
Product
SAP Analytics Cloud all versions