Table 2-3 VBA Functions—Alphabetical List
| VBA Functions | Applicable Data Sources |
|---|---|
| AnalysisProperties | Oracle Business Intelligence Enterprise Edition |
| CopyView | Oracle BI EE |
| CreateJournal | Oracle Hyperion Financial Management and Oracle Journals Extension for Financial Management |
| DeleteView | Oracle BI EE |
| DirProperties | Oracle BI EE |
| EditPagePrompts | Oracle BI EE |
| EditPrompts | Oracle BI EE |
| GetPagePrompts | Oracle BI EE |
| HypAddLRO | Oracle Essbase |
| HypCalculate | Financial Management |
| HypCalculateContribution | Financial Management (ad hoc only) |
| HypCell | Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypConnect | Essbase, Planning, Financial Management |
| HypConnected | Essbase, Planning, Financial Management |
| HypConnectionExists | Essbase, Planning, Financial Management |
| HypConsolidate | Financial Management (ad hoc only) |
| HypConsolidateAll | Financial Management (ad hoc only) |
| HypConsolidateAllWithData | Financial Management (ad hoc only) |
| HypCreateConnection | Essbase, Planning, Financial Management, Oracle Hyperion Reporting and Analysis |
| HypCreateConnectionEx | Essbase, Planning, Financial Management, Reporting and Analysis |
| HypCopyMetaData | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypDeleteAllLROs | Essbase |
| HypDeleteAllMRUItems | All |
| HypDeleteCalc | Essbase |
| HypDeleteLROs | Essbase |
| HypDeleteMetaData | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Reporting and Analysis |
| HypDisconnect | Essbase, Planning, Financial Management |
| HypDisconnectAll | Essbase, Planning, Financial Management |
| HypDisconnectEx | Essbase, Planning, Financial Management |
| HypDisplayToLinkView | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypExecuteCalcScript | Essbase |
| HypExecuteCalcScriptEx | Essbase, Planning, Oracle Planning and Budgeting Cloud |
| HypExecuteCalcScriptString | Essbase |
| HypExecuteMenu | All |
| HypExecuteDrillThroughReport | Essbase |
| HypExecuteMDXEx | Essbase |
| HypExecuteQuery | Essbase |
| HypFindMember | Essbase |
| HypFindMemberEx | Essbase |
| HypForceCalculate | Financial Management |
| HypForceCalculateContribution | Financial Management (ad hoc only) |
| HypForceTranslate | Financial Management (ad hoc only) |
| HypFreeDataPoint | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetActiveMember | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetAncestor | Essbase |
| HypGetBackgroundPOV | Essbase, Planning, Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management |
| HypGetCalcScript | Essbase |
| HypGetCellRangeForMbrCombination | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetChildren | Essbase |
| HypGetColCount | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetColItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetConnectionInfo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetDatabaseNote | Essbase |
| HypGetDataPoint | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetDimensions | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetDimMbrsForDataCell | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetDrillThroughReports | Essbase |
| HypGetGlobalOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetLastError | All |
| HypGetLinkMacro | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management, (ad hoc only) |
| HypGetMemberInformation | Essbase |
| HypGetMemberInformationEx | Essbase |
| HypGetMembers | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetNameRangeList | Essbase |
| HypGetOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetPagePOVChoices | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetParent | Essbase |
| HypGetPOVCount | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetPOVItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetRowCount | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetRowItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetSharedConnectionsURL | Essbase, Planning, Financial Management |
| HypGetSheetInfo | All |
| HypGetSheetOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypGetSourceGrid | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypGetSubstitutionVariable | Essbase |
| HypGetVersion | All |
| HypHideRibbonMenu | All |
| HypHideRibbonMenuReset | All |
| HypInvalidateSSO | Essbase, Planning, Financial Management |
| HypIsAncestor | Essbase |
| HypIsAttribute | Essbase |
| HypIsCellWritable | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypIsChild | Essbase |
| HypIsConnectedToSharedConnections | Essbase, Planning, Financial Management |
| HypIsDataModified | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypIsDescendant | Essbase |
| HypIsExpense | Essbase |
| HypIsFreeForm | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypIsParent | Essbase |
| HypIsSmartViewContentPresent | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypIsUDA | Essbase |
| HypKeepOnly | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypListApplications | Essbase, Financial Management, Planning |
| HypListCalcScripts | Essbase |
| HypListCalcScriptsEx | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypListDatabases | Essbase, Planning |
| HypListLROs | Essbase |
| HypMenuVAbout | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVAdjust | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVBusinessRules | Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVCalculation | Essbase, Financial Management (ad hoc only) |
| HypMenuVCascadeNewWorkbook | Essbase, Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVCascadeSameWorkbook | Essbase, Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVCellText | Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVCollapse | Planning (forms only), Oracle Planning and Budgeting Cloud (forms only) |
| HypMenuVConnect | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVCopyDataPoints | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVExpand | Planning (forms only), Oracle Planning and Budgeting Cloud (forms only) |
| HypMenuVFunctionBuilder | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVInstruction | Planning (forms only), Oracle Planning and Budgeting Cloud (forms only), Financial Management (forms only) |
| HypMenuVKeepOnly | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVLRO | Essbase |
| HypMenuVMemberInformation | Essbase |
| HypMenuVMemberSelection | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVMigrate | Financial Management |
| HypMenuVOptions | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVPasteDataPoints | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVPivot | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVPOVManager | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVQueryDesigner | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVRedo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVRefresh | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVRefreshAll | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVRefreshOfflineDefinition | Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVRemoveOnly | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVRulesOnForm | Planning (forms only), Oracle Planning and Budgeting Cloud (forms only) |
| HypMenuVRunReport | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVSelectForm | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVShowHelpHtml | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVSubmitData | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypMenuVSupportingDetails | Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVSyncBack | Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVTakeOffline | Planning, Oracle Planning and Budgeting Cloud |
| HypMenuVUndo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVVisualizeinExcel | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVZoomIn | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypMenuVZoomOut | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypModifyConnection | Essbase, Planning, Financial Management |
| HypModifyRangeGridName | Essbase |
| HypOpenForm | Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypOtlGetMemberInfo | Essbase |
| HypPerformAdhocOnForm | Planning, Oracle Planning and Budgeting Cloud |
| HypPivot | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypPivotToGrid | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypPivotToPOV | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypPreserveFormatting | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypQueryMembers | Essbase |
| HypRedo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypRemoveConnection | Essbase, Planning, Financial Management |
| HypRemoveOnly | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypRemovePreservedFormats | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypResetFriendlyName | Essbase, Planning, Financial Management |
| HypRetrieve | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypRetrieveAllWorkbooks | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypRetrieveLRO | Essbase |
| HypRetrieveNameRange | Essbase |
| HypRetrieveRange | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetActiveConnection | Essbase, Planning, Financial Management |
| HypSetActiveMember | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetAliasTable | Essbase, Planning, Oracle Planning and Budgeting Cloud |
| HypSetAsDefault | Essbase, Planning, Financial Management |
| HypSetBackgroundPOV | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetCellsDirty | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetColItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetConnAliasTable | Essbase, Planning |
| HypSetConnectionInfo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetDimensions | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetGlobalOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetLinkMacro | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetMembers | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetMenu | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetPages | Planning (forms only), Oracle Planning and Budgeting Cloud (forms only), Financial Management (forms only) |
| HypSetPOV | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetPOVItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetRowItems | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypSetSharedConnectionsURL | Essbase, Planning, Financial Management |
| HypSetSheetOption | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSetSSO | All providers that support Single Signon (SSO) |
| HypSetSubstitutionVariable | Essbase |
| HypShowPanel | All |
| HypShowPov | All |
| HypSubmitData | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management |
| HypSubmitSelectedDataCells | Essbase |
| HypSubmitSelectedRangeWithoutRefresh | Essbase |
| HypTranslate | Financial Management (ad hoc only) |
| HypUIConnect | Essbase, Planning, Oracle Planning and Budgeting Cloud, Financial Management, Oracle BI EE |
| HypUndo | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypUpdateLRO | Essbase |
| HypUseLinkMacro | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypZoomIn | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| HypZoomOut | Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only) |
| InsertView | Oracle BI EE |
| 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 BI EE |
| PerformAction | Financial Management and Oracle Journals Extension for Financial Management |
| 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 |