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.