SAP Knowledge Base Article - Public

3535186 - How default sort order is defined in Table in SAP Analytics Cloud.

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

  1. Open the story in SAP Analytics Cloud.
  2. Change to default sort order for members.
  3. 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

  1. Check the order of the values set in Modeler.
  2. To change the default order in table, drag the dots before this member in Modeler and move it to the desired position.

See Also

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