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

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypConnect
  • Essbase on-premises

  • Financial Management

  • Oracle Hyperion Planning

HypConnected
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypConnectionExists
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypConsolidate Financial Management (ad hoc only)
HypConsolidateAll Financial Management (ad hoc only)
HypConsolidateAllWithData Financial Management (ad hoc only)
HypCreateConnection
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

  • Oracle Hyperion Reporting and Analysis

HypCreateConnectionEx
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

  • Reporting and Analysis

HypCopyMetaData
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypDeleteAllLROs Essbase
HypDeleteAllMRUItems All
HypDeleteCalc Essbase
HypDeleteLROs Essbase
HypDeleteMetaData
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

  • Reporting and Analysis

HypDisconnect
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypDisconnectAll
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypDisconnectEx
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypDisplayToLinkView
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypExecuteCalcScript Essbase
HypExecuteCalcScriptEx
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

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

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetActiveMember
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetAncestor Essbase
HypGetBackgroundPOV
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetCalcScript Essbase on-premises
HypGetCellRangeForMbrCombination
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetColItems
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetConnectionInfo
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetDatabaseNote Essbase
HypGetDataPoint
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetDimensions
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetDimMbrsForDataCell
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetDrillThroughReports Essbase on-premises
HypGetErrorInfo All
HypGetGlobalOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetMemberInformation Essbase
HypGetMemberInformationEx Essbase
HypGetMembers
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetNameRangeList Essbase
HypGetOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetPagePOVChoices
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetPOVItems
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetRowCount
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetRowItems
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypGetSharedConnectionsURL
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetSheetInfo All
HypGetSheetOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypGetSourceGrid
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

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

  • Financial Management

  • Oracle Hyperion Planning

HypIsChild Essbase
HypIsConnectedToSharedConnections
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypIsDataModified
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypIsDescendant Essbase
HypIsExpense Essbase
HypIsFreeForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypIsParent Essbase
HypIsSmartViewContentPresent
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypListApplications
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypListCalcScripts Essbase
HypListCalcScriptsEx
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypListDatabases
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

HypListDocuments
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase cloud

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVAdjust
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVBusinessRules
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

HypMenuVCalculation Essbase

Financial Management (ad hoc only)

HypMenuVCascadeNewWorkbook
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

HypMenuVCascadeSameWorkbook
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

HypMenuVCellText
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVCollapse
  • Planning (forms only)

  • Planning Modules (forms only)

  • Financial Consolidation and Close (forms only)

  • Tax Reporting (forms only)

  • Oracle Hyperion Planning (forms only)

HypMenuVConnect
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVCopyDataPoints
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVExpand
  • Planning (forms only)

  • Planning Modules (forms only)

  • Financial Consolidation and Close (forms only)

  • Tax Reporting (forms only)

  • Oracle Hyperion Planning (forms only)

HypMenuVFunctionBuilder
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVInstruction
  • Planning (forms only)

  • Planning Modules (forms only)

  • Financial Consolidation and Close (forms only)

  • Tax Reporting (forms only)

  • Financial Management (forms only)

  • Oracle Hyperion Planning (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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVLRO Essbase
HypMenuVMemberInformation Essbase
HypMenuVMemberSelection
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVMigrate Financial Management
HypMenuVOptions
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVPasteDataPoints
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVPivot
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVPOVManager
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVQueryDesigner
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVRedo
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVRefresh
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVRefreshAll
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVRefreshOfflineDefinition
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Oracle Hyperion Planning

HypMenuVRemoveOnly
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVRulesOnForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Oracle Hyperion Planning

HypMenuVRunReport
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVSelectForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVShowHelpHtml
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVSubmitData
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypMenuVSupportingDetails
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Oracle Hyperion Planning

HypMenuVSyncBack Planning, Oracle Hyperion Planning
HypMenuVTakeOffline Planning, Oracle Hyperion Planning
HypMenuVUndo
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVVisualizeinExcel
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVZoomIn
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypMenuVZoomOut
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypModifyConnection
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypModifyRangeGridName Essbase
HypOpenForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Financial Management

  • Oracle Hyperion Planning

HypOpenFlexForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Oracle Hyperion Planning

HypOtlGetMemberInfo Essbase
HypPerformAdhocOnForm
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Oracle Hyperion Planning

HypPivot
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypPivotToGrid
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypPivotToPOV
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypPreserveFormatting
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypRemoveConnection
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypRemoveOnly
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypRemovePreservedFormats
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypResetFriendlyName
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypRetrieve
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypRetrieveAllWorkbooks
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetActiveConnection
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetActiveMember
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetAliasTable
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetAsDefault
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetBackgroundPOV
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetBasicAuthToken
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

HypSetCellsDirty
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetColItems
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Oracle Hyperion Planning

HypSetConnAliasTable
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetConnectionInfo
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetGlobalOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetLinkMacro
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetMembers
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetMenu
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetPages
  • Planning (forms only)

  • Planning Modules (forms only)

  • Financial Consolidation and Close (forms only)

  • Tax Reporting (forms only)

  • Financial Management (forms only)

  • Oracle Hyperion Planning (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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetPOVItems
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetRowItems
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypSetSharedConnectionsURL
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

HypSetSheetOption
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

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

  • Financial Management

  • Oracle Hyperion Planning

HypSubmitSelectedDataCells Essbase
HypSubmitSelectedRangeWithoutRefresh Essbase
HypTranslate Financial Management (ad hoc only)
HypUIConnect
  • Planning

  • Planning Modules

  • Financial Consolidation and Close

  • Tax Reporting

  • Essbase

  • Financial Management

  • Oracle Hyperion Planning

  • Oracle BI EE

HypUndo
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

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

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypZoomIn
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

HypZoomOut
  • Planning (ad hoc only)

  • Planning Modules (ad hoc only)

  • Financial Consolidation and Close (ad hoc only)

  • Tax Reporting (ad hoc only)

  • Essbase

  • Financial Management (ad hoc only)

  • Oracle Hyperion Planning (ad hoc only)

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