Child pages
  • Zero Suppression: Example I
Skip to end of metadata
Go to start of metadata

Zero Suppression Type 'Active'

As explained in OT-OLAP Zero Suppression, with this setting, the system checks for zero values in the results area(yellow result lines) and hides any rows or columns containing zero values. Hence, in case the result lines are hidden, this type of zero suppression is not applied.

Example

The Sample Query has two characteristics in the drilldown and uses Zero Suppression Type 'Active'

You could find the same setting in Modeling Tool:

Since the results rows are suppressed, zero suppression is not applied(query executed in Transaction RSRT):

If the display of a result row for the characteristic Customer is activated,

the query does not display data any longer:

If we now switch off zero suppression

the query result is as follows:

 

 

 

  • No labels