Zero suppression

A common feature of multidimensional databases is that for many combinations of rows and columns, there is no data and reports can contain a large number of empty cells, or zero values. Suppressing zero columns and rows also suppresses empty columns and rows.

Depending on the type of analysis or chart that you selected, the zero suppression option on categories, series, or both categories and series is available.

You can enable this option in several ways:

  • Use the Edit icon on the toolbar and select the suppression option.
  • In ad-hoc analysis, use the Zero Suppression icon on the analysis toolbar.
  • Click on any data cell in the data table and select the suppression option.
    Note: To display the data table, you can use the Explore Your Data or Show Data options, or the Table chart.