With the annotation @Analytics.settings.zeroValues, the CDS query as below suppresses the rows or columns that are all zeros (see discussion of this OLAP feature in Zero Suppression):
@EndUserText.label: 'zero suppression'
//===zero suppression section begins ===
//===zero suppression section ends ===
define view ZGLSUM_Q2 as select from ZGLSUM
where name <> 'SNOOPY'
Run the query, the result is:
After set filter as Kids = CHARLIE, TINKERBELL, the column ToyCount is suppressed as it contains only zeros:
With active feature Zero Suppression, a query with many zero cells can have a smaller result set, thus less data is transferred to frontend.