Table 20-9 Data Options Supported for Essbase Ad Hoc
| Option | Ad hoc |
|---|---|
| Suppress Rows - No Data / Missing | Yes |
| Suppress Rows - Zero | Yes |
| Suppress Rows - No Access | No |
| Invalid | No |
| Underscore Characters | No |
| Repeated Members | Yes |
| Suppress Columns - No Data / Missing | No |
| Suppress Columns - Zero | No |
| Suppress Columns - No Access | No |
| #NoData/Missing Label - #Missing | No |
| #NoData/Missing Label - #NumericZero | No |
| #NoAccess Label - #No Access | No |
| #NoAccess Label - #NumericZero | No |
| #Invalid/Meaningless -#Invalid | No |
| #Invalid/Meaningless - #NumericZero | No |
| Submit Zero | Yes |
| Display Invalid Data | No |
| Enable Essbase Format String | Yes |
| Cell Display | No |
| Navigate Without Data | Yes |
| Suppress Missing blocks | No |