Show TOC

Background documentationSuppression of Zero Rows and Columns


Zero suppression is a filter operation in the display similar to a condition. It causes rows and/or columns with zero values to be hidden after aggregation. This function is related to the result set of just one data request, i.e. to an axis. It works both for hierarchies and for result sets without hierarchies, and can be applied to structures in the drilldown.

Caution Caution

Note that error values such as DIV0, OVERFLOW or ERROR cannot be suppressed.

End of the caution.

When working with the zero suppression function, you can choose the setting variants active and active (all values = 0).

The only difference between these two queries is how they affect queries that contain characteristics in the rows and in the columns (Cross-Tab). These settings have exactly the same effect on queries that contain characteristics only in the rows or only in the columns.


With this setting, the system checks for zero values in the results area and hides any rows or columns containing zero values.

Active (All Values = 0)

With this setting, the system only hides rows or columns that contain just zero values.

Additional condition: Property of a structure

In the structure properties, you can define that zero suppression is applied to the structure components.

Note Note

In Query Designer, the standard setting is for zero values only to be suppressed if all elements = 0.

End of the note.


Query Designer

In the Properties of a Query dialog, you can define whether or not rows or columns that contain zero values should be displayed.

In the Properties of the Structure dialog, on the Display tab, you can define whether zero suppression of rows and/or columns should also be applied to the corresponding structure.

More Information