Suppress empty cells

Sparse data can result in Exploration Views showing empty cells. For example, an Exploration View that matches employees with products, results in many rows of empty values for the revenue measure if the employee does not sell those products. To remove sparse data in an Exploration View, you can suppress empty cells that contain a null or zero value.

When you are working with IBM® Cognos® Analytics data, totals-based suppression is applied. Totals-based suppression removes rows or columns where the total results in a null or zero value throughout the Exploration View. You cannot remove sparse data from individual rows or columns.