VBA Functions—Alphabetical List
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 Analytics Cloud - Essbase, 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 | Oracle Analytics Cloud - Essbase, Essbase |
| HypDeleteAllMRUItems | All |
| HypDeleteCalc | Oracle Analytics Cloud - Essbase, Essbase |
| HypDeleteLROs | Oracle Analytics Cloud - Essbase, Essbase |
| HypDeleteMetaData |
|
| HypDisconnect |
|
| HypDisconnectAll |
|
| HypDisconnectEx |
|
| HypDisplayToLinkView |
|
| HypExecuteCalcScript | Oracle Analytics Cloud - Essbase, Essbase |
| HypExecuteCalcScriptEx |
|
| HypExecuteCalcScriptString | Essbase |
| HypExecuteMenu | All |
| HypExecuteDrillThroughReport | Essbase |
| HypExecuteMDXEx | Oracle Analytics Cloud - Essbase, Essbase |
| HypExecuteQuery | Oracle Analytics Cloud - Essbase, Essbase |
| HypFindMember | Oracle Analytics Cloud - Essbase, Essbase |
| HypFindMemberEx | Oracle Analytics Cloud - Essbase, Essbase |
| HypForceCalculate | Financial Management |
| HypForceCalculateContribution | Financial Management (ad hoc only) |
| HypForceTranslate | Financial Management (ad hoc only) |
| HypFreeDataPoint |
|
| HypGetActiveMember |
|
| HypGetAncestor | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetBackgroundPOV |
|
| HypGetCalcScript | Essbase |
| HypGetCellRangeForMbrCombination |
|
| HypGetChildren | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetColCount |
|
| HypGetColItems |
|
| HypGetConnectionInfo |
|
| HypGetDatabaseNote | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetDataPoint |
|
| HypGetDimensions |
|
| HypGetDimMbrsForDataCell |
|
| HypGetDrillThroughReports | Essbase |
| HypGetGlobalOption |
|
| HypGetLastError | All |
| HypGetLinkMacro |
|
| HypGetMemberInformation | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetMemberInformationEx | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetMembers |
|
| HypGetNameRangeList | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetOption |
|
| HypGetPagePOVChoices |
|
| HypGetParent | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetPOVCount |
|
| HypGetPOVItems |
|
| HypGetRowCount |
|
| HypGetRowItems |
|
| HypGetSharedConnectionsURL |
|
| HypGetSheetInfo | All |
| HypGetSheetOption |
|
| HypGetSourceGrid |
|
| HypGetSubstitutionVariable | Oracle Analytics Cloud - Essbase, Essbase |
| HypGetVersion | All |
| HypHideRibbonMenu | All |
| HypHideRibbonMenuReset | All |
| HypInvalidateSSO | All providers that support Single Signon (SSO) |
| HypIsAncestor | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsAttribute | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsCellWritable |
|
| HypIsChild | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsConnectedToSharedConnections |
|
| HypIsDataModified |
|
| HypIsDescendant | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsExpense | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsFreeForm |
|
| HypIsParent | Oracle Analytics Cloud - Essbase, Essbase |
| HypIsSmartViewContentPresent |
|
| HypIsUDA | Oracle Analytics Cloud - Essbase, Essbase |
| HypKeepOnly |
|
| HypListApplications |
|
| HypListCalcScripts | Oracle Analytics Cloud - Essbase, Essbase |
| HypListCalcScriptsEx |
|
| HypListDatabases |
|
| HypListDocuments |
|
| HypListLROs | Oracle Analytics Cloud - Essbase, Essbase |
| HypMenuVAbout |
|
| HypMenuVAdjust |
|
| HypMenuVBusinessRules |
|
| HypMenuVCalculation |
Oracle Analytics Cloud - Essbase Essbase Financial Management (ad hoc only) |
| HypMenuVCascadeNewWorkbook |
|
| HypMenuVCascadeSameWorkbook |
|
| HypMenuVCellText |
|
| HypMenuVCollapse |
|
| HypMenuVConnect |
|
| HypMenuVCopyDataPoints |
|
| HypMenuVExpand |
|
| HypMenuVFunctionBuilder |
|
| HypMenuVInstruction |
|
| HypMenuVKeepOnly |
|
| HypMenuVLRO | Oracle Analytics Cloud - Essbase, Essbase |
| HypMenuVMemberInformation | Oracle Analytics Cloud - Essbase, 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 | Oracle Analytics Cloud - Essbase, Essbase |
| HypOpenForm |
|
| HypOtlGetMemberInfo | Oracle Analytics Cloud - Essbase, Essbase |
| HypPerformAdhocOnForm |
|
| HypPivot |
|
| HypPivotToGrid |
|
| HypPivotToPOV |
|
| HypPreserveFormatting |
|
| HypQueryMembers | Oracle Analytics Cloud - Essbase, Essbase |
| HypRedo |
|
| HypRemoveConnection |
|
| HypRemoveOnly |
|
| HypRemovePreservedFormats |
|
| HypResetFriendlyName |
|
| HypRetrieve |
|
| HypRetrieveAllWorkbooks |
|
| HypRetrieveLRO | Oracle Analytics Cloud - Essbase, Essbase |
| HypRetrieveNameRange | Oracle Analytics Cloud - Essbase, Essbase |
| HypRetrieveRange |
|
| HypSetActiveConnection |
|
| HypSetActiveMember |
|
| HypSetAliasTable |
|
| HypSetAsDefault |
|
| HypSetBackgroundPOV |
|
| HypSetCellsDirty |
|
| HypSetColItems |
|
| HypSetConnAliasTable |
|
| HypSetConnectionInfo |
|
| HypSetCustomHeader | Oracle Analytics Cloud - Essbase |
| HypSetDimensions |
|
| HypSetGlobalOption |
|
| HypSetLinkMacro |
|
| HypSetMembers |
|
| HypSetMenu |
|
| HypSetOption |
|
| HypSetPages |
|
| HypSetPOV |
|
| HypSetPOVItems |
|
| HypSetRowItems |
|
| HypSetSharedConnectionsURL |
|
| HypSetSheetOption |
|
| HypSetSSO | All providers that support Single Signon (SSO) |
| HypSetSubstitutionVariable | Oracle Analytics Cloud - Essbase, Essbase |
| HypShowPanel | All |
| HypShowPov | All |
| HypSubmitData |
|
| HypSubmitSelectedDataCells | Oracle Analytics Cloud - Essbase, Essbase |
| HypSubmitSelectedRangeWithoutRefresh | Oracle Analytics Cloud - Essbase, Essbase |
| HypTranslate | Financial Management (ad hoc only) |
| HypUIConnect |
|
| HypUndo |
|
| HypUpdateLRO | Oracle Analytics Cloud - Essbase, 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 |