3361209 - Zero/Null suppression does not work for the collapsed hierarchy nodes in SAP Analytics Cloud (SAC)

In an SAP Analytics Cloud (SAC) story containing a BW Live model. The table has a hierarchy active and the hierarchy is not fully expanded, it has at least one node collapsed.

The Zero Suppression is active for rows or columns, however, a column or row with all cells with zero or null values is not being suppressed.

If the hierarchy node is expanded, the zero (or null) rows/columns are removed. And 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.

"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 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 , Problem