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/ODE story 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/ODE Story 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.
An existing enhancement request for this topic had already been submitted : "Sort by Description instead of ID " (https://influence.sap.com/sap/ino/#/idea/316864

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.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

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

Product

SAP Analytics Cloud all versions