- Create a story with a table based on a model with BW live connection, the query contains a measure using Reverse Sign function.
- Create a TOP N on this key figure in SAC.
- The result is based on original value instead of Reverse Sign result.
For example, the measure has original values 1, 2, 3. It shows -1,-2 ,-3 if Reverse Sign is turned on. After create a TOP 2 on this measure, it should show -1,-2, but the result is -2 ,-3.
SAP BusinessObjects Cloud 1.0
This is a limitation at this moment - until wave 2020.2. The developers are checking whether an enhancement will be introduced.
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.
SAC, SAP Analytics Cloud, key figure, Sign Change, Keep +/- Sign, bex query, condition, disregard , KBA , LOD-ANA-BI-BW , SAP BW Connectivity with SAP Analytics Cloud , LOD-ANA-BI-APP , Analytics Designer and Data Analyzer , Problem