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