3361209 - Zero/Null suppression does not work for the collapsed hierarchy nodes in SAP Analytics Cloud (SAC) and SAP S/4HANA Fiori app

SAP Analytics Cloud (SAC) Story with a BW Live model has a table widget with an active hierarchy. The hierarchy is not fully expanded, it has at least one node collapsed.

The issue happens when Zero Suppression is active for rows or columns: a row or column with all it's cells with zero or null values is not being suppressed as expected.

If the hierarchy node mentioned above is expanded, the zero (or null) rows/columns are removed. A business scenario requires that this row is suppressed even though the hierarchy is collapsed.

Note: The issue can be reproduced in transaction RSRT (see KBA 2500671) using ABAP BICS mode. Upon using HTML mode Zero Suppression works as expected and the hierarchy node is suppressed even if it has a collapsed node.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

• SAP Analytics Cloud
• SAP Business Warehouse
• SAP S/4HANA
• SAP BW4/HANA
• SAP Netweaver

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, parent member, compress, compression, empty, 0, hierarchical , KBA , BW-BEX-OT-OLAP , Analyzing Data , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-TAB , Table , BW-BEX-OT-BICS-INA , BW INA provider , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , Problem