Contents

• Documentation Accessibility
• Documentation Feedback
• Copyright Page
• About the Smart View Developer's Guide

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

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

General Functions

• About General Functions
• HypShowPanel
• HypGetVersion
• HypGetLastError
• HypShowPov
• HypSetMenu
• HypCopyMetaData
• HypDeleteMetaData
• HypIsDataModified
• HypIsSmartViewContentPresent
• HypIsFreeForm
• HypUndo
• HypRedo
• HypPreserveFormatting
• HypRemovePreservedFormats
• HypSetAliasTable
• HypGetSubstitutionVariable
• HypSetSubstitutionVariable
• HypGetDatabaseNote

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

Ad Hoc Functions

• About Ad Hoc Functions
• HypPerformAdhocOnForm
• HypRetrieve
• HypRetrieveRange
• HypRetrieveNameRange
• HypGetNameRangeList
• HypRetrieveAllWorkbooks
• HypExecuteQuery
• HypSubmitData
• HypPivot
• HypPivotToGrid
• HypPivotToPOV
• HypKeepOnly
• HypRemoveOnly
• HypZoomIn
• HypZoomOut

Form Functions

• About Forms
• HypOpenForm

Cell Functions

• About Cell Functions
• HypGetDimMbrsForDataCell
• HypCell
• HypFreeDataPoint
• HypGetCellRangeForMbrCombination
• HypGetDataPoint
• HypIsCellWritable
• HypSetCellsDirty
• HypDeleteAllLROs
• HypDeleteLROs
• HypAddLRO
• HypUpdateLRO
• HypListLROs
• HypRetrieveLRO
• HypExecuteDrillThroughReport
• HypGetDrillThroughReports

POV Functions

• About POV Functions
• HypSetPOV
• HypGetBackgroundPOV
• HypSetBackgroundPOV
• HypGetPagePOVChoices
• HypSetPages
• HypGetMembers
• HypSetMembers
• HypGetActiveMember
• HypSetActiveMember
• HypGetDimensions
• HypSetDimensions

Calculation Script and Business Rule Functions

• About Calculation Script and Business Rule Functions
• HypListCalcScripts
• HypExecuteCalcScript
• HypListCalcScriptsEx
• HypExecuteCalcScriptEx
• HypDeleteCalc

Calculation, Consolidation, and Translation Functions

• About Calculation, Consolidation, and Translation Functions
• HypCalculate
• HypCalculateContribution
• HypConsolidate
• HypConsolidateAll
• HypConsolidateAllWithData
• HypForceCalculate
• HypForceCalculateContribution
• HypForceTranslate
• HypTranslate

Member Query Functions

• About Member Query Functions
• HypFindMember
• HypFindMemberEx
• HypGetAncestor
• HypGetChildren
• HypGetParent
• HypIsAttribute
• HypIsDescendant
• HypIsAncestor
• HypIsExpense
• HypIsParent
• HypIsChild
• HypIsUDA
• HypOtlGetMemberInfo
• HypQueryMembers
• HypGetMemberInformation
• HypGetMemberInformationEx

Options Functions

• About Options Functions
• HypGetGlobalOption
• HypSetGlobalOption
• HypGetSheetOption
• HypSetSheetOption
• HypGetOption
• HypSetOption
• HypDeleteAllMRUItems

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

MDX Query Functions

• About MDX
• HypExecuteMDXEx

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