HypRetrieveLRO
Describes the Oracle Smart View for Office VBA function, HypRetrieveLRO.
Cloud data provider types: Oracle Essbase
On-premises data provider types: Oracle Essbase
Description
HypRetrieveLRO() retrieves linked reporting objects associated with the cells specified by the vtSelectionRange parameter. To see the linked reporting objects, you must launch the Linked Reporting Objects dialog box or or use HypListLRO.
Syntax
HypRetrieveLRO(vtSheetName, vtSelectionRange, vtID,vtlType, vtName, vtDescription)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByVal vtID As Variant
ByVal vtName As Variant
ByVal vtDescription 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 to associate with the linked reporting object
vtID: Input variable;the ID of the linked reporting object to be retrieved. This is provided when you execute HypListLROs.
vtName: Output variable;the name of the linked reporting object
vtDescription: Output variable; the description of the retrieved linked reporting object
Return Value
Returns 0 if successful; otherwise, returns the corresponding error code.
Example
Public Declare Function HypRetrieveLRO Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByVal vtID As Variant,ByRef vtName As Variant,ByRef vtDescription As Variant) As Long
Sub Example_HypRetrieveLRO
sts = HypRetrieveLRO("Sheet1", Range("B3"), "1", vtName, vtDescription)
End Sub