Showing or Hiding Empty Tables, Rows or Columns

Sometimes tables or specific rows and columns display no values. For example, if a sales of a specific product are discontinued, table rows or columns that normally show results for that product appear empty. By default, Web Intelligence displays such empty rows, columns, or tables. You can choose to display or hide empty tables, rows or columns.

To show or hide empty tables, rows or columns

1.    Select within the table, right-click and select Format > Table on the menu. The Properties tab displays the table formatting options.

2.    Select Display > Show when empty to display empty tables.

3.    Select Display > Show rows/columns with empty measure values to display rows or columns with empty measure values.

4.    Select Display > Show rows/columns with empty dimension values to display rows/columns with empty dimension values.