Table 8-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 | N/A | 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 |