Symptom
- The order of members in dimensions is not consistent with either Ascending or Descending on ID/Description.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Open the story in SAP Analytics Cloud.
- Change to default sort order for members.
- Yet notice that the order for some nodes is ascending, some is descending.
Cause
The default order in table or chart is based on the order defined in Modeler.
Resolution
- Check the order of the values set in Modeler.
- To change the default order in table, drag the dots before this member in Modeler and move it to the desired position.
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, default sort order, dimensions, member order, model, backend, table, chart. , KBA , LOD-ANA-TAB-SOR , Table Sort, Ranking, Member Sort, Value sort, Custom Sort , Problem
Product
SAP Analytics Cloud all versions