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 |