SAP Knowledge Base Article - Preview

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


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.



  • SAP Analytics Cloud 2018.4.0
  • SAP Business Warehouse 7.5 SP7


SAP Analytics Cloud 1.0 ; SAP NetWeaver 7.5


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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.