SUPEMPTYROWS

The Essbase Report Writer SUPEMPTYROWS command suppresses the display of empty rows – that is, rows that have only 0 or #MISSING values in the row.

Syntax

{ SUPEMPTYROWS }

Notes

The report will contain only rows which have at least one data value which is neither #MISSING nor zero.

Example

{SUPEMPTYROWS} would suppress the display of the following row in a report:

Qtr1   Actual 0  #Missing  0  0  #Missing

INCEMPTYROWS

INCMISSINGROWS

INCZEROROWS

SUPMISSINGROWS

SUPZEROROWS