You can remove rows or columns that do not contain data. The row or column is removed only if the entire row or column has no data. If any cell has data, even zeros, the row or column will not be removed.
![]() |
Using the Suppress missing rows and Suppress missing columns option might result in empty queries. |
To suppress missing rows or columns:
When you click the Apply button the changes are implemented but the dialog box remains open.
![]() |
When the Suppress missing rows or Suppress missing columns option is enabled, if the data source is a Microsoft Analysis Services data source, you also enable the query optimization that enhances the data drilling performance. However, if you drill down and then perform other data analysis operations such as drilling up, changing page filter, or using Dimension Explorer, the data you see may be incomplete. To ensure all relevant data appear, disable the Suppress missing rows and Suppress missing columns options and perform the drill down operation again before your other data analysis operations. However, by disabling these options, you also disable the query optimization. This may result in performance degradation. |