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. 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 icon on the toolbar and select the suppression option.
- In ad-hoc analysis, use the 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 or options, or the chart.