Data Options Supported for Planning Forms and Ad Hoc
Oracle Planning and Budgeting Cloud users: In the Planning web application, your administrator can use the Smart View Suppression Behavior option to change suppression behavior when both the Oracle Smart View for Office No Data/Missing and Zero suppression options for rows, or columns, or both are selected.
If the Smart View Suppression Behavior option in Planning is set to:
-
Legacy—Only suppresses rows or columns containing either all No Data/Missing or all Zeros. Does not suppress rows or columns containing a combination of No Data/Missing and Zeros.
For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for rows, and a row contains both zeroes and Missing labels, then the row is displayed; it is not suppressed.
-
Standard—Suppresses rows or columns containing all No Data/Missing or all Zeros, or a combination of both.
For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for columns, and a column contains both zeroes and Missing labels, then the column is suppressed; it is not displayed.
Table 20-6 Data Options Supported for Planning 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 | No | No |
| Underscore Characters | No | No |
| Repeated Members | No | Yes |
| Suppress Columns - No Data / Missing | Yes | Yes |
| Suppress Columns - Zero | Yes | Yes |
| Suppress Columns - No Access | Yes | Yes |
| #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 | No | No |
| #Invalid/Meaningless - #NumericZero | No | No |
| Submit Zero | No if #NoData/Missing Label is set to #No Access.
Yes if #NoData/Missing Label is set to #NumericZero |
No if #NoData/Missing Label is set to #No Access.
Yes if #NoData/Missing Label is set to #NumericZero |
| Display Invalid Data | No | No |
| Enable Essbase Format String | No | No |
| Cell Display | No | No |
| Navigate Without Data | Yes | Yes |
| Suppress Missing blocks | Yes | Yes |