SAP Knowledge Base Article - Public

2615382 - Bottom N Filtering in charts issues when zero supression is enabled in SAP Analytics Cloud (SAC)

Symptom

When applying a Bottom N filter to a chart in an SAP Analytics Cloud story whilst zero supression is active in the BEx Query, then all 0 values will not be displayed but will be counted towards the N value. For example, if a Bottom 5 filter is applied, and there are 3 records which have 0 values, then only 2 records will be shown, despite the requirement to see the bottom 5 values, excluding the records with 0 values.

Environment

  • SAP Analytics Cloud 2018.4.0
  • SAP Business Warehouse 7.5 SP7

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Create a story using a BW Live Data Connection which has "Supress Zeros" enabled as a parameter on the BEx Query
  3. Add a bar/column chart under the 'Comparison' within the Builder tab
  4. Apply a bottom N filter by hovering over the chart and clicking the "Choose Top N Options" button.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Supress Zeros , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0