Hiding Zero and Booked Null Values in a Table

Hide zero and booked null values in a table.

Context

As a story editor, you may not want to show zero and booked null values in a table.
Note

There are some differences in behavior depending on whether you're working with SAP BW or SAP HANA. For more details, see the table below.

SAP BW SAP HANA (analytic models)
Hide zero and null values on either rows or columns, or both simultaneously. Hide zero or null values on all rows and columns.
Hide zero and null values on all cells, or on totals. Hide zero or null values on cells. Rows or columns are removed if all cells along the row or column are zero or null.
Restriction

In SAP HANA, the ability to hide zero and null values is currently not supported for planning models (SAP Note 2982539 Information published on SAP site).

Procedure

  1. Create a table and add rows and columns to it.
  2. In the Builder, select a row or column, then select Start of the navigation path (More) Next navigation step Zero SuppressionEnd of the navigation path.
    Specific to SAP BW:
    Two further options appear:

    • All Cells

    • Totals

  3. Specific to SAP BW: Select All Cells or Totals, depending on where in the table you want to hide zero and/or booked null values.

    Zero and booked null values are no longer shown in your table. A message appears stating that zero suppression is applied.

  4. To show zeros and booked nulls in your table again, in the Builder select the area that has zero suppression switched on. Select Start of the navigation path (More) Next navigation step Zero SuppressionEnd of the navigation path.

    The table is updated to show zero and booked null values.

    Note

    1. Unbooked Data and Zero Suppression are mutually exclusive, meaning that both options can't be applied at the same time. If you select Zero Suppression while Unbooked Data is already selected, a message appears informing you of this, and asking you if you want to turn off Unbooked Data. Once you select OK, the Zero Suppression option you selected is applied.

    2. Specific to SAP BW:

      The Zero Suppression selection applied to a row persists, even if you drag and drop that row to the column area in the Builder. Similarly, switching off the Zero Suppression option in the column area doesn't switch it off in the row area.

      On SAP HANA the function is applied on the entire table.

    3. Hiding zero and null values isn't supported on tables based on planning models.

    4. Booked mode is disabled in View mode on the table context menu when you've selected to hide zero or null values. This applies to analytic models only.