Sheet Information Support in Essbase
Cloud data source types: Oracle Essbase
On-premises data source types: Oracle Essbase
Table 16-18 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 |