SAP Knowledge Base Article - Public

3553649 - Issue with Default Sort in German Language in SAP SuccessFactors Story reports

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 in Story reports. 

Environment

  • SAP SuccessFactors

    • SAP SuccessFactors Story reports

Reproducing the Issue

  1. Log in to the instance.
  2. Navigate to report center.
  3. Run the story 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:

  • SAC 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 Report. This ensures the data is sorted by the description field using the correct locale.

See Also

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

    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 , LOD-SF-ANA-SAC , Stories in People Analytics , Product Enhancement

    Product

    SAP Analytics Cloud all versions ; SAP SuccessFactors Platform all versions