SAP Knowledge Base Article - Public

3607077 - Sorting of filter members in ascending order is incorrect in SAP Analytics Cloud (SAC).

Symptom

Story filter members ("text" type as description) and sorted in ascending order is displayed in incorrect order in SAC.

Environment

SAP Analytics Cloud version 2024.21.11

 

Reproducing the Issue

  1. Login to SAC tenant
  2. Open the story in edit mode
  3. Click on filter dropdown from filter panel
  4. Click on sort-> ascending

    Notice that filter description is not sorted alphabetically in ascending order.

 

 

Cause

The filter may persist previous text and caused the inconsistency of display text (short) and the text BW backend sorted on (medium). 

Resolution

Enable the toggle for ‘Respect text representation that are defined at the BW Query level’ in SAC by navigating to System --> Administration --> System Configuration

See Also

 

Keywords

SAC, SAP Analytics Cloud, story filter, incorrect sort , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem

Product

SAP Analytics Cloud 1.0