Table of Contents
- Title and Copyright Information
- Documentation Accessibility
- Documentation Feedback
- 1 About the Oracle Smart View for Office Developer's Guide
- 2 About VBA Functions
-
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
- HypListApplications
- HypListDatabases
- HypGetLastError
- HypShowPov
- HypSetMenu
- HypCopyMetaData
- HypDeleteMetaData
- HypIsDataModified
- HypIsSmartViewContentPresent
- HypIsFreeForm
- HypUndo
- HypRedo
- HypPreserveFormatting
- HypRemovePreservedFormats
- HypSetAliasTable
- HypGetSubstitutionVariable
- HypSetSubstitutionVariable
- HypGetDatabaseNote
- HypGetSheetInfo
- HypListDocuments
- HypListUserVariables
- HypSetUserVariable
-
5
Connection Functions
- About Connection Functions
- HypConnect
- HypUIConnect
- HypConnected
- HypConnectionExists
- HypCreateConnection
- HypCreateConnectionEx
- HypSetCustomHeader
- HypUpdateConnection
- HypModifyConnection
- HypDisconnect
- HypDisconnectAll
- HypDisconnectEx
- HypGetSharedConnectionsURL
- HypSetSharedConnectionsURL
- HypIsConnectedToSharedConnections
- HypRemoveConnection
- HypSetSSO
- HypInvalidateSSO
- HypResetFriendlyName
- HypSetActiveConnection
- HypSetAsDefault
- HypSetConnAliasTable
-
6
Ad Hoc Functions
- About Ad Hoc Functions
- HypPerformAdhocOnForm
- HypRetrieve
- HypRetrieveRange
- HypRetrieveNameRange
- HypCreateRangeGrid
- HypModifyRangeGridName
- HypGetNameRangeList
- HypRetrieveAllWorkbooks
- HypExecuteQuery
- HypSubmitData
- HypSubmitSelectedRangeWithoutRefresh
- HypSubmitSelectedDataCells
- HypPivot
- HypPivotToGrid
- HypPivotToPOV
- HypKeepOnly
- HypRemoveOnly
- HypZoomIn
- HypZoomOut
- 7 Form Functions
- 8 Cell Functions
- 9 POV Functions
- 10 Calculation Script and Business Rule Functions
- 11 Calculation, Consolidation, and Translation Functions
- 12 Member Query Functions
- 13 Options Functions
-
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
-
16
Oracle Journals for Financial Management Functions
- About Oracle Journals for Financial Management Functions
- Registering the Oracle Journals VBA Functions Using RegAsm
- Preparing to Work with Oracle Journals for Financial Management Functions
- Instantiating an Oracle Journals for Financial Management Extension Object
- Oracle Journals for Financial Management Extension Functions
- 17 Oracle Analytics Cloud Functions
- 18 Oracle BI EE Functions