Sheet Information Support in Essbase
Cloud data source types: Oracle Analytics Cloud - Essbase
On-premises data source types: Oracle Essbase
Table 9-17 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 Guidelines ) | Yes (see Sheet Information Guidelines) | Yes | Yes (see Sheet Information Guidelines) | No |
| Set as Default Connection, before associate with active connection | No (see Sheet Information Guidelines) | Yes (see Sheet Information Guidelines) | Yes | Yes (see Sheet Information Guidelines) | No |
| Set as Default Connection, after associating with active connection | Yes (see Sheet Information Guidelines) | Yes (see Sheet Information Guidelines) | Yes | Yes (see Sheet Information Guidelines) | No |
| Last Retrieved | Yes |