Table 14 lists the Smart View VBA functions alphabetically. A detailed description for each function, including the syntax, parameter, return value, and sample code, follows the table.
Table 14. VBA Functions and Supported Providers
VBA Functions
HypCalculate
HypCalculateContribution
HypCell
HypConnect
HypConnected
HypConnectionExists
HypConsolidate
HypConsolidateAll
HypConsolidateAllWithData
HypCopyMetaData
HypCreateConnection
HypDeleteCalc
HypDeleteMetadata
HypDisconnect
HypDisconnectEx
HypExecuteCalcScript
HypExecuteCalcScriptEx
HypExecuteQuery
HypFindMember
HypFindMemberEx
HypForceCalculate
HypForceCalculateContribution
HypForceTranslate
HypFreeDataPoint
HypGetAncestor
HypGetChildren
HypGetCellRangeForMbrCombination
HypGetColCount
HypGetColItems
HypGetConnectionInfo
HypGetDataPoint
HypGetDimMbrsForDataCell
HypGetGlobalOption
HypGetLinkMacro
HypGetParent
HypGetPOVCount
HypGetPOVItems
HypGetRowCount
HypGetRowItems
HypGetSharedConnectionsURL
HypGetSheetOption
HypGetSourceGrid
HypGetSubstitutionVariable
HypIsAttribute
HypIsDescendant
HypIsExpense
HypIsFreeForm
HypIsParent
HypIsSmartViewContentPresent
HypIsUDA
HypKeepOnly
HypListCalcScripts
HypListCalcScriptsEx
HypOtlGetMemberInfo
HypPivot
HypPivotToGrid
HypPivotToPOV
HypPreserveFormatting
HypQueryMembers
HypRedo
HypRemoveConnection
HypRemoveOnly
HypResetFriendlyName
HypRetrieve
HypSetActiveConnection
HypSetAliasTable
HypSetBackgroundPOV
HypSetCellsDirty
HypSetColItems
HypSetConnectionInfo
HypSetGlobalOption
HypSetLinkMacro
HypSetMenu
HypSetPOV
HypSetPOVItems
HypSetRowItems
HypSetSharedConnectionsURL
HypSetSheetOption
HypSetSubstitutionVariable
HypSubmitData
HypTranslate
HypUndo
HypUseLinkMacro
HypZoomIn
HypZoomOut