SAP Knowledge Base Article - Public

3156692 - SAC AD : Is it possible to sort by Description instead of ID ?

Symptom

  • When trying to sort a Table in an Analytic Application using the "Table_1.sortByMember("Dimension", SortOrder.Ascending);" formula, the function is working as expected.
  • It is sorting by the ID of the Dimension. Is it possible to sort the Dimension using its Description ?
    Sort_Description.jpg

Environment

  •  SAP Analytics Cloud - Analytics Designer

Cause

Analytics Designer doesn't have a standard feature to sort by description. Only the ID of the dimension can be sorted.

Resolution

For missing features and functionality, this request of sorting by Description of dimension would be qualified as an enhancement request, to submit in our "Continuous Influence" program.

You can find more details here : 2424376 - How do you create an enhancement request for SAP Analytics Cloud? .

The "Customer Influence and Adopt" site for SAC is "https://influence.sap.com/sap/ino/#/campaign/884" which is dedicated to requests for enhancements to SAP SAC products, with interactivity with other clients (forum) and our Product Group.
Continuous Influence is a great program for customers and partners to share feedback / ideas that help enhance SAP solutions in production.

Keywords

sort, sortByMember, sortOrder , KBA , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud all versions