Sheet Information Support in Essbase

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase

Table 17-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