Table 5. Sheet Information Supported by Essbase
Connection Status | Single Grid | Multiple Grid | VBA (HypExecuteMenu) | Formulas | Functions (HsGetVal, HsGetSheetInfo) |
|---|---|---|---|---|---|
| Shared Connection | Yes | Yes | Yes | Yes | No |
| Private Connection | Yes | Yes | Yes | Yes | No |
| Private Connection—Set as Default Connection | Yes | Yes | Yes | Yes | No |
| No Connection, open new blank worksheet | No | No | No | No | No |
| No connection, open a saved worksheet | Yes | Yes | Yes | No | No |
| Set Active Connection for this Worksheet | Yes (see Sheet Information Notes) | Yes (see Sheet Information Notes) | Yes | Yes (see Sheet Information Notes) | No |
| Set as Default Connection, before associate with active connection | No (see Sheet Information Notes) | Yes (see Sheet Information Notes) | Yes | Yes (see Sheet Information Notes) | No |
| Set as Default Connection, after associating with active connection | Yes (see Sheet Information Notes) | Yes (see Sheet Information Notes) | Yes | Yes (see Sheet Information Notes) | No |