Zero suppression

A common feature of multidimensional databases is that they are "hypersparse". For many combinations of rows and columns, there is no data and reports can contain a large number of empty cells, or zero values. You can exclude columns and rows which contain only zero values or columns and rows which contain no values. Suppressing zero columns and rows also suppresses empty columns and rows. But suppressing empty columns and rows does not suppress zero values.

When you use zero suppression, any column or row which contains only zero values is hidden. If the column or row contains at least one non-zero value, the zero values in that column or row are still shown. 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.