Table 8-8 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 Example 8-1) | Yes (see Example 8-1) | Yes | Yes (see Example 8-1) | No |
| Set as Default Connection, before associate with active connection | No (see Example 8-1) | Yes (see Example 8-1) | Yes | Yes (see Example 8-1) | No |
| Set as Default Connection, after associating with active connection | Yes (see Example 8-1) | Yes (see Example 8-1) | Yes | Yes (see Example 8-1) | No |
| Last Retrieved | Yes |