Suppressing Rows

You can suppress the following types of rows:

Missing Rows (Essbase only)—Suppresses the retrieval of any missing rows where all cells are null.
Zero Rows (Essbase only)—Suppresses the retrieval of any zero rows where all cells are null.
Empty Rows (OLE DB only)—Suppresses the retrieval of any empty rows for which there is no measure data.

To suppress rows in your OLAPQuery data, select OLAP , then OLAP Query Options and click the DB Specific tab.

The options that are displayed on the DB Specific tab depend on the database to which you are connected. See Database-specific OLAPQuery Options for more information.