Data provider types: Essbase
HypGetDrillThroughReports() retrieves a list of drill-through reports. See also HypExecuteDrillThroughReport.
HypGetDrillThroughReports(vtSheetName, vtSelectionRange, vtIDs, vtNames, vtURLs, vtURLTemplates, vtTypes)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByVal vtIDs As Variant
ByVal vtNames As Variant
ByVal vtURLs As Variant
ByVal vtURLTemplates As Variant
ByVal vtTypes As Variant
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtSelectionRange: The range of cells that contain the drill-through reports to retrieve
vtIDs: Output variable; the array of the IDs returned from the server
vtNames: Output variable; the array of the names returned from the server
vtURLs: Output variable; the array of the URLs returned from the server
vtURLTemplates: Output variable; the array of the URL templates returned from the server
vtTypes: Output variable; the array of the types returned from the server
Returns 0 if successful; otherwise, returns the appropriate error code.
Public Declare Function HypGetDrillThroughReports Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByRef vtIDs As Variant,ByRef vtNames As Variant,ByRef vtURLs As Variant,ByRef vtURLTemplates As Variant,ByRef vtTypes As Variant) As Long Sub Example_HypGetDrillThroughReports() sts = HypGetDrillThroughReports("Sheet3", Range("B3"), ids, names, urls, urltemplates, types) End Sub