HypExecuteDrillThroughReport
Describes the Oracle Smart View for Office VBA function, HypExecuteDrillThroughReport.
Data provider types: Oracle Essbase
Description
HypExecuteDrillThroughReport() executes the specified drill-through report. See also HypGetDrillThroughReports.
Syntax
HypExecuteDrillThroughReport(vtSheetName, vtSelectionRange, vtID, vtName, vtURL, vtURLTemplate, vtType)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByVal vtID As Variant
ByVal vtName As Variant
ByVal vtURL As Variant
ByVal vtURLTemplate As Variant
ByVal vtType As Variant
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtSelectionRange: Input variable; the range of cells in which to execute the drill-through report
vtID: Input variable; the ID for the execution of the drill-through report. This is returned from the server when you run HypGetDrillThroughReports.
vtName: Input variable; the name of the drill-through report. This is returned from the server when you run HypGetDrillThroughReports.
vtURL: Input variable; the URL of the drill-through report. This is returned from the server when you run HypGetDrillThroughReports.
vtURLTemplate: Input variable; the URL template of the drill-through report. This is returned from the server when you run HypGetDrillThroughReports.
vtType: Input variable; the type of the drill-through report. This is returned from the server when you run HypGetDrillThroughReports.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypExecuteDrillThroughReport Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByVal vtID As Variant,ByVal vtName As Variant,ByVal vtURL As Variant,ByVal vtURLTemplate As Variant,ByVal vtType As Variant) As Long
Sub Example_HypExecuteDrillThroughReport()
sts = HypExecuteDrillThroughReport("Sheet3", Range("B3"), ids(0), names(0), "", "", "")
End Sub