SAP Knowledge Base Article - Public

3553649 - Issue with Default Sort in German Language in SAP SuccessFactors People Analytics

Symptom

  • The default sorting of dimensions in non-English languages (e.g., German) in Charts and Tables does not align with the expected A-Z sort order based on localized descriptions. 

Environment

  • SAP SuccessFactors People Analytics.
  • SAP SuccessFactors HXM Suite.

Reproducing the Issue

  1. Log in to the instance.
  2. Navigate to report center.
  3. Run the report.
  4. Observe that the alphabetical sorting works correctly when logged in English.
  5. Change the language setting to German and run the report again.
  6. Observe that the alphabetical sorting does not follow the German labels but continues to follow the English labels.

Cause

This behavior is by design:

  • When no explicit sort order is specified (Default Sort), the back-end determines the order of the data.
  • The back-end orders by ID (key), which in this case corresponds to the English representation of the member.
  • Chart and Table widgets in SAC display data exactly as it is returned by the back-end.

When an A-Z sort is applied:

  • SAP Analytics Cloud explicitly requests sorting on the description field using the locale specified.
  • This results in the expected A-Z order of descriptions.

Resolution

To achieve the desired sorting behavior:

  • Apply an explicit A-Z sort to the Chart or Table widget during the design phase of the Story. This ensures the data is sorted by the description field using the correct locale.

See Also

2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?

Keywords

SAP Analytics Cloud, Alphabetical Sorting, Job Application Category, German Language, Cross-Tab Tables, Story Reports, Sort Order, Language Settings, Localized Settings. , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , LOD-ANA-DES , Story Design & Visualizations , Product Enhancement

Product

SAP Analytics Cloud all versions