SAP Knowledge Base Article - Public

2877453 - reverse sign is ignored in TOP N on SAC

Symptom

  1. Create a story with a table based on a model with BW live connection, the query contains a measure using Reverse Sign function.
  2. Create a TOP N on this key figure in SAC.
  3. 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.

Environment

SAP BusinessObjects Cloud 1.0

Cause

This is a limitation at this moment - until wave 2020.2. The developers are checking whether an enhancement will be introduced.

Resolution

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.

Keywords

SAC, SAP Analytics Cloud, key figure, Sign Change, Keep +/- Sign, bex query, condition, disregard , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0