Data Options
Data options are sheet level options, which are specific to the worksheet for which they are set.
Note:
Not all data providers support all the options listed in Table 20-5. Refer to the Subtopics listed earlier to find the options supported for a particular provider.
To set options for the display of data cells as described in Table 20-5, 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.
See also:
Table 20-5 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.
Notes:
|
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 Oracle Hyperion 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). |
Repeated Members | 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:
|
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, by default, Oracle Smart View for Office displays
The |
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.
|
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 | Applies to Financial Management (on-premises) only. |
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. |
The sections that follow list the Data Options supported by provider.