Data Options

Set Data options to control the display of data cells.

To set data options:

  1. In the Extensions menu, select Smart View for Google Workspace, and then select Options.
  2. In the Options dialog, select the Data tab.
  3. Make selections in the Data tab as described in Data Options.
  4. Optional: To save your Data tab selections as the default selections for any new content that you import from a data source, select the Advanced tab, and then click Save Current Options as Default.
  5. Click OK to save the changes.

Data Options

Table 5-2 Data Options

Option Description
Row Suppression To streamline the grid, you can suppress rows that contain types of data that you do not need to view.
Zero Suppress rows that contain only zeroes.
Invalid Suppress rows that contain only invalid values.
Missing Suppress rows that contain only cells for which no data exists in the database. No data is not the same as zero. Zero is a data value.
Underscore Suppress rows that contain underscore characters in member names.
Column Suppression To streamline the grid, you can suppress columns that contain types of data that you do not need to view.
Zero Suppress columns that contain only zeroes.
Invalid Display actual data even if it is invalid, rather than #Invalid/Meaningless or other replacement text. If no data exists, the cell is left blank.
Missing Suppress columns that contain cells for which no data exists in the database No data is not the same as zero. Zero is a data value.

If you later clear No Data/Missing, suppressed values are returned only from that point on. You must zoom out and then zoom in on a member to retrieve values that were suppressed while this option was selected.

Underscore Suppress columns that contain underscore characters in member names.
Block Suppression Block Suppression
Suppress Missing Blocks Suppress blocks of cells for which no data exists in the database.
Replacement Replacement

Missing/No Data Label

No Access Label

 Data cells may contain missing data or data that you do not have permission to view. In such cells, by default, Smart View displays #Missing or #No Access, respectively, but you can change these labels.

The #Missing replacement label enables you to clear data values from cell intersections. For example, to clear the sales data for New York, manually type #Missing in the cell where Sales and New York intersect, and click Submit. This clears the data value from the database. Subsequent queries on that database will show #Missing at the intersection of Sales and New York.

To change the labels, in any of these fields, enter the text of your choice (or leave the default). Text labels have the advantage of being descriptive, but they cause Google Sheets functions to fail.

In the #Missing field, you can enter #NumericZero to specify numeric zero (0) replacement labels. With #NumericZero, you can use functions, but you cannot submit zeroes to the database (even if the zeroes are actual zeroes and not replacement labels) unless you select the Submit Zero check box. Calculations that are dependent on a cell with a numeric zero label compute correctly and take the value of the cell as zero.

Submit Zero If you chose #NumericZero for the #Missing label above, select this option if you want to be able to submit zeroes to the database.
Ad Hoc Mode Ad Hoc Mode
Navigate Without Data Speeds up operations such as Pivot, Zoom, Keep Only, and Remove Only by preventing the calculation of source data while you are navigating. When you are ready to retrieve data, clear Navigate Without Data.