VBA Functions—Alphabetical List

Describes the alphabetical listing of VBA functions, including menu functions.

Table 3-3 VBA Functions—Alphabetical List

VBA Functions	Applicable Data Sources
AnalysisProperties	Oracle Analytics Cloud
CopyView	Oracle Analytics Cloud
DeleteView	Oracle Analytics Cloud
DirProperties	Oracle Analytics Cloud
EditPagePrompts	Oracle Analytics Cloud
EditPrompts	Oracle Analytics Cloud
GetPagePrompts	Oracle Analytics Cloud
HypAddLRO	Oracle Essbase
HypCell	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypConnected	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypConnectionExists	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypCreateConnection	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypCreateConnectionEx	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypCopyMetaData	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypDeleteAllLROs	Essbase
HypDeleteAllMRUItems	All
HypDeleteCalc	Essbase
HypDeleteLROs	Essbase
HypDeleteMetaData	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypDisconnect	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypDisconnectAll	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypDisconnectEx	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypDisplayToLinkView	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypExecuteCalcScript	Essbase
HypExecuteCalcScriptEx	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypExecuteCalcScriptEx2	Essbase
HypExecuteMenu	All
HypExecuteMDXEx	Essbase
HypExecuteQuery	Essbase
HypFindMember	Essbase
HypFindMemberEx	Essbase
HypFreeDataPoint	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetActiveMember	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetAncestor	Essbase
HypGetBackgroundPOV	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetCellRangeForMbrCombination	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetChildren	Essbase
HypGetColCount	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetColItems	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetConnectionInfo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetDatabaseNote	Essbase
HypGetDataPoint	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetDimensions	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetDimMbrsForDataCell	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetErrorInfo	All
HypGetGlobalOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetLastError	All
HypGetLinkMacro	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetMemberInformation	Essbase
HypGetMemberInformationEx	Essbase
HypGetMembers	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetNameRangeList	Essbase
HypGetOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetPagePOVChoices	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetParent	Essbase
HypGetPOVCount	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetPOVItems	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetRowCount	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetRowItems	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetSharedConnectionsURL	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetSheetInfo	All
HypGetSheetOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypGetSourceGrid	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypGetSubstitutionVariable	Essbase
HypGetVersion	All
HypHideRibbonMenu	All
HypHideRibbonMenuReset	All
HypInvalidateSSO	All providers that support Single Signon (SSO)
HypIsAncestor	Essbase
HypIsAttribute	Essbase
HypIsCellWritable	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypIsChild	Essbase
HypIsConnectedToSharedConnections	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypIsDataModified	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypIsDescendant	Essbase
HypIsExpense	Essbase
HypIsFreeForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypIsParent	Essbase
HypIsSmartViewContentPresent	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypIsUDA	Essbase
HypKeepOnly	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypListApplications	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypListCalcScripts	Essbase
HypListCalcScriptsEx	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypListDatabases	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypListDocuments	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase cloud
HypListLROs	Essbase
HypListUserVariables	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypLoginEssbaseCloudBasicAuth	Oracle Essbase cloud
HypMenuVAbout	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVAdjust	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVBusinessRules	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVCalculation	Essbase
HypMenuVCascadeNewWorkbook	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVCascadeSameWorkbook	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVCellText	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypMenuVCollapse	Planning (forms only) Planning Modules (forms only) Financial Consolidation and Close (forms only) Tax Reporting (forms only)
HypMenuVConnect	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVCopyDataPoints	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVExpand	Planning (forms only) Planning Modules (forms only) Financial Consolidation and Close (forms only) Tax Reporting (forms only)
HypMenuVFunctionBuilder	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVInstruction	Planning (forms only) Planning Modules (forms only) Financial Consolidation and Close (forms only) Tax Reporting (forms only)
HypMenuVKeepOnly	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVLRO	Essbase
HypMenuVMemberInformation	Essbase
HypMenuVMemberSelection	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVOptions	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVPasteDataPoints	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVPivot	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVPOVManager	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVQueryDesigner	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVRedo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVRefresh	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVRefreshAll	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVRefreshOfflineDefinition	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypMenuVRemoveOnly	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVRulesOnForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypMenuVRunReport	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVSelectForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVShowHelpHtml	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVSubmitData	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypMenuVSupportingDetails	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypMenuVUndo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVVisualizeinExcel	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVZoomIn	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypMenuVZoomOut	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypModifyConnection	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypModifyRangeGridName	Essbase
HypOpenForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypOpenFlexForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypOtlGetMemberInfo	Essbase
HypPerformAdhocOnForm	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypPivot	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypPivotToGrid	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypPivotToPOV	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypPreserveFormatting	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypQueryMembers	Essbase
HypRedo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypRemoveConnection	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypRemoveOnly	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypRemovePreservedFormats	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypResetFriendlyName	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypRetrieve	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypRetrieveAllWorkbooks	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypRetrieveLRO	Essbase
HypRetrieveNameRange	Essbase
HypRetrieveRange	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetActiveConnection	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetActiveMember	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetAliasTable	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetAsDefault	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetBackgroundPOV	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetBasicAuthToken	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypSetCellsDirty	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetColItems	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetConnAliasTable	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetConnectionInfo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetCustomHeader	Essbase cloud
HypSetDimensions	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetGlobalOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetLinkMacro	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetMembers	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetMenu	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetPages	Planning (forms only) Planning Modules (forms only) Financial Consolidation and Close (forms only) Tax Reporting (forms only)
HypSetPOV	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetPOVItems	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetRowItems	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypSetSharedConnectionsURL	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetSheetOption	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSetSSO	All providers that support Single Signon (SSO)
HypSetSubstitutionVariable	Essbase
HypSetUserVariable	Planning Planning Modules Financial Consolidation and Close Tax Reporting
HypShowPanel	All
HypShowPov	All
HypSubmitData	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypSubmitSelectedDataCells	Essbase
HypSubmitSelectedRangeWithoutRefresh	Essbase
HypUIConnect	Planning Planning Modules Financial Consolidation and Close Tax Reporting Essbase
HypUndo	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypUpdateLRO	Essbase
HypUseLinkMacro	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypZoomIn	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
HypZoomOut	Planning (ad hoc only) Planning Modules (ad hoc only) Financial Consolidation and Close (ad hoc only) Tax Reporting (ad hoc only) Essbase
InsertView	Oracle Analytics Cloud
InvokeMenu	Oracle Analytics Cloud
PasteView	Oracle Analytics Cloud

Note:

In this guide:

• 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.