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
- Log into Tenant
- Navigate to the story link:
- Click on the chart, go into chart options by select the three dots
- Hover over "rank" and expand the options
- Select Top N Options
- Ensure All Dimensions are selected
- Select "top" for mode and "2" for Value
- See that the bottom 2 values appears as opposed to the top 2 values that are needed
- 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