3502800 - Top N Ranking functionality in SAC Story is Reveresed

• 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

• SAP Analytics Cloud 2024.8

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

• The issue is due to a common limitation in OLAP engine.

As a workaround, create a formula and multiply the original key figure with -1 in query definition as per SAP Note 2028029, That is: define F=key figure * (-1), it has the same values as "reverse sign" is used. Then define TOP N on formula F in SAC.

• BW Sign Reversal (SAP Library - Business Intelligence)
• 2877453- reverse sign is ignored in TOP N on SAC
• 2028029- Condition doesn't Work with Reverse Sign

SAC, Story, Ranking, Top N, Bottom N, Chart  , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem