Go to main content
1/238
Contents
Title and Copyright Information
Documentation Accessibility
Documentation Feedback
1
About the Smart View Developer's Guide
2
About VBA Functions
Assumed Knowledge
VBA Functions Location
Using VBA Function Code Samples
VBA Functions in 64-Bit Versions
VBA Parameters
VBA Return Values
Using Spreadsheet Toolkit VBA Applications in Smart View
VBA Function Types
VBA Functions—Alphabetical List
3
Menu Functions
About Menu Functions
HypMenuVAbout
HypMenuVAdjust
HypMenuVBusinessRules
HypMenuVCalculation
HypMenuVCascadeNewWorkbook
HypMenuVCascadeSameWorkbook
HypMenuVCellText
HypMenuVCollapse
HypMenuVConnect
HypMenuVCopyDataPoints
HypMenuVExpand
HypMenuVFunctionBuilder
HypMenuVInstruction
HypMenuVKeepOnly
HypMenuVLRO
HypMenuVMemberInformation
HypMenuVMemberSelection
HypMenuVMigrate
HypMenuVOptions
HypMenuVPasteDataPoints
HypMenuVPivot
HypMenuVPOVManager
HypMenuVQueryDesigner
HypMenuVRedo
HypMenuVRefresh
HypMenuVRefreshAll
HypMenuVRefreshOfflineDefinition
HypMenuVRemoveOnly
HypMenuVRulesOnForm
HypMenuVRunReport
HypMenuVSelectForm
HypMenuVShowHelpHtml
HypMenuVSubmitData
HypMenuVSupportingDetails
HypMenuVSyncBack
HypMenuVTakeOffline
HypMenuVUndo
HypMenuVVisualizeinExcel
HypMenuVZoomIn
HypMenuVZoomOut
HypExecuteMenu
HypHideRibbonMenu
HypHideRibbonMenuReset
4
General Functions
About General Functions
HypShowPanel
HypGetVersion
HypGetLastError
HypShowPov
HypSetMenu
HypCopyMetaData
HypDeleteMetaData
HypIsDataModified
HypIsSmartViewContentPresent
HypIsFreeForm
HypUndo
HypRedo
HypPreserveFormatting
HypRemovePreservedFormats
HypSetAliasTable
HypGetSubstitutionVariable
HypSetSubstitutionVariable
HypGetDatabaseNote
5
Connection Functions
About Connection Functions
HypConnect
HypUIConnect
HypConnected
HypConnectionExists
HypCreateConnection
HypCreateConnectionEx
HypModifyConnection
HypModifyRangeGridName
HypDisconnect
HypDisconnectAll
HypDisconnectEx
HypGetSharedConnectionsURL
HypSetSharedConnectionsURL
HypIsConnectedToSharedConnections
HypRemoveConnection
HypInvalidateSSO
HypResetFriendlyName
HypSetActiveConnection
HypSetAsDefault
HypSetConnAliasTable
6
Ad Hoc Functions
About Ad Hoc Functions
HypPerformAdhocOnForm
HypRetrieve
HypRetrieveRange
HypRetrieveNameRange
HypCreateRangeGrid
HypGetNameRangeList
HypRetrieveAllWorkbooks
HypExecuteQuery
HypSubmitData
HypSubmitSelectedRangeWithoutRefresh
HypSubmitSelectedDataCells
HypPivot
HypPivotToGrid
HypPivotToPOV
HypKeepOnly
HypRemoveOnly
HypZoomIn
HypZoomOut
7
Form Functions
About Forms
HypOpenForm
8
Cell Functions
About Cell Functions
HypGetDimMbrsForDataCell
HypCell
HypFreeDataPoint
HypGetCellRangeForMbrCombination
HypGetDataPoint
HypIsCellWritable
HypSetCellsDirty
HypDeleteAllLROs
HypDeleteLROs
HypAddLRO
HypUpdateLRO
HypListLROs
HypRetrieveLRO
HypExecuteDrillThroughReport
HypGetDrillThroughReports
9
POV Functions
About POV Functions
HypSetPOV
HypGetBackgroundPOV
HypSetBackgroundPOV
HypGetPagePOVChoices
HypSetPages
HypGetMembers
HypSetMembers
HypGetActiveMember
HypSetActiveMember
HypGetDimensions
HypSetDimensions
10
Calculation Script and Business Rule Functions
About Calculation Script and Business Rule Functions
HypListCalcScripts
HypExecuteCalcScript
HypListCalcScriptsEx
HypExecuteCalcScriptEx
HypDeleteCalc
11
Calculation, Consolidation, and Translation Functions
About Calculation, Consolidation, and Translation Functions
HypCalculate
HypCalculateContribution
HypConsolidate
HypConsolidateAll
HypConsolidateAllWithData
HypForceCalculate
HypForceCalculateContribution
HypForceTranslate
HypTranslate
12
Member Query Functions
About Member Query Functions
HypFindMember
HypFindMemberEx
HypGetAncestor
HypGetChildren
HypGetParent
HypIsAttribute
HypIsDescendant
HypIsAncestor
HypIsExpense
HypIsParent
HypIsChild
HypIsUDA
HypOtlGetMemberInfo
HypQueryMembers
HypGetMemberInformation
HypGetMemberInformationEx
13
Options Functions
About Options Functions
HypGetGlobalOption
HypSetGlobalOption
HypGetSheetOption
HypSetSheetOption
HypGetOption
HypSetOption
HypDeleteAllMRUItems
14
Dynamic Link Functions
About Dynamic Link Views
Setting Up Dynamic Link Views
Automating Macro Execution
HypUseLinkMacro
HypSetLinkMacro
HypGetLinkMacro
HypGetSourceGrid
HypDisplayToLinkView
HypGetConnectionInfo
HypSetConnectionInfo
HypGetRowCount
HypGetColCount
HypGetPOVCount
HypGetRowItems
HypSetRowItems
HypGetColItems
HypSetColItems
HypGetPOVItems
HypSetPOVItems
15
MDX Query Functions
About MDX
HypExecuteMDXEx
16
Oracle BI EE Functions
About Oracle BI EE Functions
Preparing to Work with Oracle BI EE Functions
Instantiating an Oracle Smart View BI Extension Object
Oracle Smart View BI Extension Functions
InsertView
EditPrompts
EditPagePrompts
GetPagePrompts
DeleteView
AnalysisProperties
DirProperties
InvokeMenu
CopyView
PasteView
Scripting on this page enhances content navigation, but does not change the content in any way.