Table 1. Undo Operations Supported by Essbase
Operation | Single Grid | Multiple Grid | VBA | Functions |
|---|---|---|---|---|
Ad Hoc | ||||
| Zoom in | Supported | N/A | N/A | N/A |
| Zoom Out | Supported | N/A | N/A | N/A |
| Keep Only | Supported | N/A | N/A | N/A |
| Remove Only | Supported | N/A | N/A | N/A |
| Pivot | Supported | N/A | N/A | N/A |
| Refresh | Supported | N/A | N/A | N/A |
Member Options | ||||
| General | ||||
| Zoom In Level | Supported | N/A | N/A | N/A |
| Member Name Display | Supported | N/A | N/A | N/A |
| Indentation | Supported | N/A | N/A | N/A |
| Ancestor Position | Supported | N/A | N/A | N/A |
| Member Retention | ||||
| Include Selection | Supported | N/A | N/A | N/A |
| Within Selected Group | Supported | N/A | N/A | N/A |
| Remove Unselected Groups | Supported | N/A | N/A | N/A |
| Comments and Formulas | ||||
| Preserve Formulas and Comments in ad hoc operations (except pivot) | Preserve Excel Formulas: Not Supported Preserve Smart View Functions: Not Supported | N/A | N/A | N/A |
—Formula Fill | Preserve Excel Formulas: Not Supported Preserve Smart View Functions: Not Supported | |||
—Enable Enhanced Comment Handling | Preserve Comments: Supported | |||
| Preserve Formula on POV Change | N/A | N/A | N/A | N/A |
Data Options | ||||
| Rows | ||||
| Suppress No Data/Missing | Supported | N/A | N/A | N/A |
| Zero | Supported | N/A | N/A | N/A |
| No Access | Supported | N/A | N/A | N/A |
| Invalid | Supported | N/A | N/A | N/A |
| Underscore Characters | Supported | N/A | N/A | N/A |
| Repeated Members | Supported | N/A | N/A | N/A |
| Columns | ||||
| Suppress No Data/Missing | Supported | N/A | N/A | N/A |
| Zero | Supported | N/A | N/A | N/A |
| No Access | Supported | N/A | N/A | N/A |
| Mode | ||||
| Suppress Missing Blocks | Supported | N/A | N/A | N/A |
| Modify Open Saved | Not Supported | N/A | N/A | N/A |
| Alias Table | Supported | N/A | N/A | N/A |
| Metadata (member data) | Not Supported | N/A | N/A | N/A |
| Cell Style | N/A | N/A | N/A | N/A |