Data Options

Data options are sheet level options, which are specific to the worksheet for which they are set.

To set options for the display of data cells as described in Table 14, click Options on the Smart View ribbon, and then select Data Options in the left panel. When you are finished, make a selection for saving the changes:

OK
Save as Default Options
Apply to All Worksheets
Note:
The Apply to All Worksheets option is not available in PowerPoint or Word.

See Sheet Options for a complete description of the above options.

Note:

Not all data providers support all the options listed in the table.

Table 14. Data Options

Option	Description
Suppress Rows	To streamline the grid, you can suppress rows that contain types of data that you do not need to view. Note: In suppressed rows, cell references to Excel formulas are not updated.
No Data/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.) 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.
Zero	Suppress rows that contain only zeroes.
No Access	Suppress rows that contain data that you do not have the security access to view. Note: This option is supported by Financial Management only.
Invalid	Suppress rows that contain only invalid values.
Underscore Characters	Suppress rows that contain underscore characters in member names (not available in Smart Slice operations).
	Suppress rows that contain repeated member names, regardless of grid orientation.
Suppress Columns	To streamline the grid, you can suppress columns that contain types of data that you do not need to view. Notes: In suppressed columns, cell references to Excel formulas are not updated. The Suppress Columns options are not available when connected to an Essbase data source. The Suppress Columns options are not supported when performing ad hoc with Financial Management data sources.
No Data/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.
Zero	Suppress columns that contain only zeroes.
No Access	Suppress columns that contain data that you do not have the security access to view.
Replacement	Replacement
#NoData/Missing Label #NoAccess Label #Invalid/Meaningless	Data cells may contain missing or invalid data, or data that you do not have permission to view. In such cells, Smart View by default displays #Missing, #Invalid,or #No Access, respectively, but you can change these labels. To do so, in any of these fields, enter one of the following: Text of your choice (or leave the default). Text labels have the advantage of being descriptive, but they cause Excel functions to fail. #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 Submit Zero. 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	Select if you entered #NumericZero above and want to be able to submit zeroes to the database.
Display Invalid Data	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.
Enable Essbase Format String	If the administrator has created specific formatting for the display of numerical data, view data in this formatting.
Mode	Mode
Cell Display	As an alternative to displaying actual data, you can display the calculation or process status of the cells: Data to show actual data Calculation Status to show whether data needs to be calculated, translated, or consolidated Process Management to show the entities level (Financial Management) or Approvals level for combinations of data called process units (Planning)
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.
Suppress Missing blocks	Suppress blocks of cells for which no data exists in the database.