VBA Functions—Alphabetical List
Describes the alphabetical listing of VBA functions, including menu functions.
Table 2-3 VBA Functions—Alphabetical List
| VBA Functions | Applicable Data Sources | 
|---|---|
| AnalysisProperties | Oracle Analytics Cloud | 
| AnalysisProperties | Oracle Business Intelligence Enterprise Edition | 
| CopyView | Oracle Analytics Cloud | 
| CopyView | Oracle BI EE | 
| CreateJournal | Oracle Hyperion Financial Management and Oracle Journals Extension for Financial Management | 
| DeleteView | Oracle Analytics Cloud | 
| DeleteView | Oracle BI EE | 
| DirProperties | Oracle Analytics Cloud | 
| DirProperties | Oracle BI EE | 
| EditPagePrompts | Oracle Analytics Cloud | 
| EditPagePrompts | Oracle BI EE | 
| EditPrompts | Oracle Analytics Cloud | 
| EditPrompts | Oracle BI EE | 
| GetPagePrompts | Oracle Analytics Cloud | 
| GetPagePrompts | Oracle BI EE | 
| HypAddLRO | Oracle Essbase | 
| HypCalculate | Financial Management | 
| HypCalculateContribution | Financial Management (ad hoc only) | 
| HypCell | 
                                 
  | 
                           
| HypConnect | 
                                 
  | 
                           
| HypConnected | 
                                 
  | 
                           
| HypConnectionExists | 
                                 
  | 
                           
| HypConsolidate | Financial Management (ad hoc only) | 
| HypConsolidateAll | Financial Management (ad hoc only) | 
| HypConsolidateAllWithData | Financial Management (ad hoc only) | 
| HypCreateConnection | 
                                 
  | 
                           
| HypCreateConnectionEx | 
                                 
  | 
                           
| HypCopyMetaData | 
                                 
  | 
                           
| HypDeleteAllLROs | Essbase | 
| HypDeleteAllMRUItems | All | 
| HypDeleteCalc | Essbase | 
| HypDeleteLROs | Essbase | 
| HypDeleteMetaData | 
                                 
  | 
                           
| HypDisconnect | 
                                 
  | 
                           
| HypDisconnectAll | 
                                 
  | 
                           
| HypDisconnectEx | 
                                 
  | 
                           
| HypDisplayToLinkView | 
                                 
  | 
                           
| HypExecuteCalcScript | Essbase | 
| HypExecuteCalcScriptEx | 
                                 
  | 
                           
| HypExecuteCalcScriptEx2 | Essbase | 
| HypExecuteCalcScriptString | Essbase on-premises | 
| HypExecuteMenu | All | 
| HypExecuteDrillThroughReport | Essbase on-premises | 
| HypExecuteMDXEx | Essbase | 
| HypExecuteQuery | Essbase | 
| HypFindMember | Essbase | 
| HypFindMemberEx | Essbase | 
| HypForceCalculate | Financial Management | 
| HypForceCalculateContribution | Financial Management (ad hoc only) | 
| HypForceTranslate | Financial Management (ad hoc only) | 
| HypFreeDataPoint | 
                                 
  | 
                           
| HypGetActiveMember | 
                                 
  | 
                           
| HypGetAncestor | Essbase | 
| HypGetBackgroundPOV | 
                                 
  | 
                           
| HypGetCalcScript | Essbase on-premises | 
| HypGetCellRangeForMbrCombination | 
                                 
  | 
                           
| HypGetChildren | Essbase | 
| HypGetColCount | 
                                 
  | 
                           
| HypGetColItems | 
                                 
  | 
                           
| HypGetConnectionInfo | 
                                 
  | 
                           
| HypGetDatabaseNote | Essbase | 
| HypGetDataPoint | 
                                 
  | 
                           
| HypGetDimensions | 
                                 
  | 
                           
| HypGetDimMbrsForDataCell | 
                                 
  | 
                           
| HypGetDrillThroughReports | Essbase on-premises | 
| HypGetErrorInfo | All | 
| HypGetGlobalOption | 
                                 
  | 
                           
| HypGetLastError | All | 
| HypGetLinkMacro | 
                                 
  | 
                           
| HypGetMemberInformation | Essbase | 
| HypGetMemberInformationEx | Essbase | 
| HypGetMembers | 
                                 
  | 
                           
| HypGetNameRangeList | Essbase | 
| HypGetOption | 
                                 
  | 
                           
| HypGetPagePOVChoices | 
                                 
  | 
                           
| HypGetParent | Essbase | 
| HypGetPOVCount | 
                                 
  | 
                           
| HypGetPOVItems | 
                                 
  | 
                           
| HypGetRowCount | 
                                 
  | 
                           
| HypGetRowItems | 
                                 
  | 
                           
| HypGetSharedConnectionsURL | 
                                 
  | 
                           
| HypGetSheetInfo | All | 
| HypGetSheetOption | 
                                 
  | 
                           
| HypGetSourceGrid | 
                                 
  | 
                           
| HypGetSubstitutionVariable | Essbase | 
| HypGetVersion | All | 
| HypHideRibbonMenu | All | 
| HypHideRibbonMenuReset | All | 
| HypInvalidateSSO | All providers that support Single Signon (SSO) | 
| HypIsAncestor | Essbase | 
| HypIsAttribute | Essbase | 
| HypIsCellWritable | 
                                 
  | 
                           
| HypIsChild | Essbase | 
| HypIsConnectedToSharedConnections | 
                                 
  | 
                           
| HypIsDataModified | 
                                 
  | 
                           
| HypIsDescendant | Essbase | 
| HypIsExpense | Essbase | 
| HypIsFreeForm | 
                                 
  | 
                           
| HypIsParent | Essbase | 
| HypIsSmartViewContentPresent | 
                                 
  | 
                           
| HypIsUDA | Essbase | 
| HypKeepOnly | 
                                 
  | 
                           
| HypListApplications | 
                                 
  | 
                           
| HypListCalcScripts | Essbase | 
| HypListCalcScriptsEx | 
                                 
  | 
                           
| HypListDatabases | 
                                 
  | 
                           
| HypListDocuments | 
                                 
  | 
                           
| HypListLROs | Essbase | 
| HypListUserVariables | 
                                 
  | 
                           
| HypMenuVAbout | 
                                 
  | 
                           
| HypMenuVAdjust | 
                                 
  | 
                           
| HypMenuVBusinessRules | 
                                 
  | 
                           
| HypMenuVCalculation | Essbase Financial Management (ad hoc only)  | 
                           
| HypMenuVCascadeNewWorkbook | 
                                 
  | 
                           
| HypMenuVCascadeSameWorkbook | 
                                 
  | 
                           
| HypMenuVCellText | 
                                 
  | 
                           
| HypMenuVCollapse | 
                                 
  | 
                           
| HypMenuVConnect | 
                                 
  | 
                           
| HypMenuVCopyDataPoints | 
                                 
  | 
                           
| HypMenuVExpand | 
                                 
  | 
                           
| HypMenuVFunctionBuilder | 
                                 
  | 
                           
| HypMenuVInstruction | 
                                 
  | 
                           
| HypMenuVKeepOnly | 
                                 
  | 
                           
| HypMenuVLRO | Essbase | 
| HypMenuVMemberInformation | Essbase | 
| HypMenuVMemberSelection | 
                                 
  | 
                           
| HypMenuVMigrate | Financial Management | 
| HypMenuVOptions | 
                                 
  | 
                           
| HypMenuVPasteDataPoints | 
                                 
  | 
                           
| HypMenuVPivot | 
                                 
  | 
                           
| HypMenuVPOVManager | 
                                 
  | 
                           
| HypMenuVQueryDesigner | 
                                 
  | 
                           
| HypMenuVRedo | 
                                 
  | 
                           
| HypMenuVRefresh | 
                                 
  | 
                           
| HypMenuVRefreshAll | 
                                 
  | 
                           
| HypMenuVRefreshOfflineDefinition | 
                                 
  | 
                           
| HypMenuVRemoveOnly | 
                                 
  | 
                           
| HypMenuVRulesOnForm | 
                                 
  | 
                           
| HypMenuVRunReport | 
                                 
  | 
                           
| HypMenuVSelectForm | 
                                 
  | 
                           
| HypMenuVShowHelpHtml | 
                                 
  | 
                           
| HypMenuVSubmitData | 
                                 
  | 
                           
| HypMenuVSupportingDetails | 
                                 
  | 
                           
| HypMenuVSyncBack | Planning, Oracle Hyperion Planning | 
| HypMenuVTakeOffline | Planning, Oracle Hyperion Planning | 
| HypMenuVUndo | 
                                 
  | 
                           
| HypMenuVVisualizeinExcel | 
                                 
  | 
                           
| HypMenuVZoomIn | 
                                 
  | 
                           
| HypMenuVZoomOut | 
                                 
  | 
                           
| HypModifyConnection | 
                                 
  | 
                           
| HypModifyRangeGridName | Essbase | 
| HypOpenForm | 
                                 
  | 
                           
| HypOpenFlexForm | 
                                 
  | 
                           
| HypOtlGetMemberInfo | Essbase | 
| HypPerformAdhocOnForm | 
                                 
  | 
                           
| HypPivot | 
                                 
  | 
                           
| HypPivotToGrid | 
                                 
  | 
                           
| HypPivotToPOV | 
                                 
  | 
                           
| HypPreserveFormatting | 
                                 
  | 
                           
| HypQueryMembers | Essbase | 
| HypRedo | 
                                 
  | 
                           
| HypRemoveConnection | 
                                 
  | 
                           
| HypRemoveOnly | 
                                 
  | 
                           
| HypRemovePreservedFormats | 
                                 
  | 
                           
| HypResetFriendlyName | 
                                 
  | 
                           
| HypRetrieve | 
                                 
  | 
                           
| HypRetrieveAllWorkbooks | 
                                 
  | 
                           
| HypRetrieveLRO | Essbase | 
| HypRetrieveNameRange | Essbase | 
| HypRetrieveRange | 
                                 
  | 
                           
| HypSetActiveConnection | 
                                 
  | 
                           
| HypSetActiveMember | 
                                 
  | 
                           
| HypSetAliasTable | 
                                 
  | 
                           
| HypSetAsDefault | 
                                 
  | 
                           
| HypSetBackgroundPOV | 
                                 
  | 
                           
| HypSetCellsDirty | 
                                 
  | 
                           
| HypSetColItems | 
                                 
  | 
                           
| HypSetConnAliasTable | 
                                 
  | 
                           
| HypSetConnectionInfo | 
                                 
  | 
                           
| HypSetCustomHeader | Essbase cloud | 
| HypSetDimensions | 
                                 
  | 
                           
| HypSetGlobalOption | 
                                 
  | 
                           
| HypSetLinkMacro | 
                                 
  | 
                           
| HypSetMembers | 
                                 
  | 
                           
| HypSetMenu | 
                                 
  | 
                           
| HypSetOption | 
                                 
  | 
                           
| HypSetPages | 
                                 
  | 
                           
| HypSetPOV | 
                                 
  | 
                           
| HypSetPOVItems | 
                                 
  | 
                           
| HypSetRowItems | 
                                 
  | 
                           
| HypSetSharedConnectionsURL | 
                                 
  | 
                           
| HypSetSheetOption | 
                                 
  | 
                           
| HypSetSSO | All providers that support Single Signon (SSO) | 
| HypSetSubstitutionVariable | Essbase | 
| HypSetUserVariable | 
                                 
  | 
                           
| HypShowPanel | All | 
| HypShowPov | All | 
| HypSubmitData | 
                                 
  | 
                           
| HypSubmitSelectedDataCells | Essbase | 
| HypSubmitSelectedRangeWithoutRefresh | Essbase | 
| HypTranslate | Financial Management (ad hoc only) | 
| HypUIConnect | 
                                 
  | 
                           
| HypUndo | 
                                 
  | 
                           
| HypUpdateLRO | Essbase | 
| HypUseLinkMacro | 
                                 
  | 
                           
| HypZoomIn | 
                                 
  | 
                           
| HypZoomOut | 
                                 
  | 
                           
| InsertView | Oracle Analytics Cloud | 
| InsertView | Oracle BI EE | 
| InvokeMenu | Oracle Analytics Cloud | 
| InvokeMenu | Oracle BI EE | 
| ListJournals | Financial Management and Oracle Journals Extension for Financial Management | 
| ListTemplates | Financial Management and Oracle Journals Extension for Financial Management | 
| OpenJournal | Financial Management and Oracle Journals Extension for Financial Management | 
| PasteView | Oracle Analytics Cloud | 
| PasteView | Oracle BI EE | 
| PerformAction | Financial Management and Oracle Journals Extension for Financial Management | 
| Retrieve | Oracle BI EE | 
| SaveJournal | Financial Management and Oracle Journals Extension for Financial Management | 
| SetJournalProperty | Financial Management and Oracle Journals Extension for Financial Management | 
| ValidateJournal | Financial Management and Oracle Journals Extension for Financial Management | 
Note:
In this guide:- 
                           
                           
Oracle Essbase on Oracle Cloud Infrastructure via Marketplace is referred to as "Essbase cloud."
 - 
                           
                           
Essbase on Independent Deployments is referred to as "Essbase on-premises."
 - 
                           
                           
When a guideline or caveat applies to both Essbase cloud and Essbase on-premises, then simply "Essbase" is used.