Data Options Supported for Financial Management Forms and Ad Hoc
Starting with Oracle Smart View for Office 11.1.2.5.500 and Oracle Hyperion Financial Management 11.1.2.4.100, when opening a data form, Smart View honors all row and column suppress options set in the Financial Management web interface, overriding any row and column suppress options that may have already been set in Smart View.
Once a form is launched in Smart View, you may then override the suppress options that were set in the Financial Management interface by selecting or clearing the suppress options you require in the Data Options tab of the Options dialog box.
Note that once you launch a form in Smart View, if you choose to overwrite the form on the sheet with an ad hoc grid, the grid will reuse the suppress options that were already set for the previously-opened form. You may then override the selected suppress options as you require.
Table 5-10 Data Options Supported for Financial Management Forms and Ad Hoc
| Option | Forms | Ad Hoc |
|---|---|---|
| Suppress Rows - No Data / Missing | Yes | Yes |
| Suppress Rows - Zero | Yes | Yes |
| Suppress Rows - No Access | Yes | Yes |
| Invalid | Yes | Yes |
| Underscore Characters | Yes | Yes |
| Repeated Members | No | Yes |
| Suppress Columns - No Data / Missing | Yes | No |
| Suppress Columns - Zero | Yes | No |
| Suppress Columns - No Access | Yes | No |
| #NoData/Missing Label - #Missing | Yes | Yes |
| #NoData/Missing Label - #NumericZero | Yes | Yes |
| #NoAccess Label - #No Access | Yes | Yes |
| #NoAccess Label - #NumericZero | Yes | Yes |
| #Invalid/Meaningless -#Invalid | Yes | Yes |
| #Invalid/Meaningless - #NumericZero | Yes | Yes |
| Submit Zero | No | No |
| Display Invalid Data | Yes | Yes |
| Enable Essbase Format String | No | No |
| Use Expense Type | No | No |
| Enable Attribute Association Processing | No | No |
| Cell Display - Data | Yes | Yes |
| Cell Display - Calculation Status | Yes | Yes |
| Cell Display - Process Management | Yes | Yes |
| Navigate Without Data | Yes | Yes |
| Suppress Missing Blocks | No | No |