SAP Knowledge Base Article - Public

3502800 - Top N Ranking functionality in SAC Story is Reveresed

Symptom

  • Top N Chart functionality does not work properly when BEx query has Reverse Sign enabled
  • When Reverse Sign is enabled, Top N shows Bottom N, Bottom N shows Top N. The behavior is completely reversed

Environment

  • System Type: HaaS
  • FPA Version: 2024.8.20
  • Update Group: Group6-EU-CF

Reproducing the Issue

  1. Log into Tenant
  2. Navigate to the story link:
    1. Click on the chart, go into chart options by select the three dots
    2. Hover over "rank" and expand the options
    3. Select Top N Options 
    4. Ensure All Dimensions are selected 
    5. Select "top" for mode and "2" for Value 
    6. See that the bottom 2 values appears as opposed to the top 2 values that are needed 
    7. Change the rank to top 2 values and we see the opposite, where the top 2 values are appearing instead of the bottom 2

    Cause

    • The cause is under investigation 

    Resolution

    • The solution is under investigation 

    See Also

    Keywords

    SAC, Story, Ranking, Top N, Bottom N, Chart  , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

    Product

    SAP Analytics Cloud 1.0