Data Options

Data Options control the display of data cells.

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 24-5. Refer to the subtopics listed in this section to find the options supported for a particular provider.

To set options for the display of data cells as described in Table 24-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.

Table 24-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.

In multiple-grid sheets, submitting data values '0 and &nd does not work properly when the No Data/Missing is set to '0 or &nd.

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 only supported by Oracle Hyperion Financial Management (on-premises) 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:

  • In suppressed columns, cell references to Excel formulas are not updated.

  • The Suppress Columns options are not available when connected to an Oracle Essbase data source.

  • The Suppress Columns options are not supported when performing ad hoc with Financial Management data sources.

  • EPM Cloud: See Data Options Supported for EPM Cloud Forms and Ad Hoc for information on using the No Data/Missing and Zero column suppression options.

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 #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 the Submit Zero option below. Calculations that are dependent on a cell with a numeric zero label compute correctly and take the value of the cell as zero.

    Note: When you enter #NumericZero, ensure that the Submit Zero option is selected to ensure that the parent data is deleted when spreading data for time periods.

The #Missing replacement label allows 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.

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.
Use Expense Type Essbase only:

Inverts the signage (positive to negative or negative to positive) for data in columns related to revenue, liability, and owner's equity accounts. Supported for aggregate storage databases only.

To use this option, ensure that your Essbase administrator has set up your application to display expense type signage.

Enable Attribute Association Processing

Oracle Analytics Cloud - Essbase and Essbase only:

Select to display #Invalid or #NumericZero for cells that are empty only because they are not associated with the context attribute or varying attribute.

By default, the Enable Attribute Association Processing option is cleared, and the empty cells display as #Missing.

See also, Enabling Attribute Association Processing in Ad Hoc Grids.

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.