Using zero suppression to hide zero values

Key query and zero suppression are similar, but with an important difference. Key Query actively searches for non-zero values to display. Zero suppression hides zero values which are returned by the combination of elements which you select.

For dimensions used as row or column headers, you can specify that only elements associated with data are displayed.

You can apply zero suppression in the Properties dialogs of the column and row dimensions. Or, you can apply zero suppression in the Define Alea Ad-hoc Report dialog.