HypRetrieve
Describes the Oracle Smart View for Office VBA function, HypRetrieve.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning (ad hoc only), Oracle Hyperion Financial Management (ad hoc only)
Description
HypRetrieve() retrieves data from the database.
Essbase only: HypRetrieve does not support creating a multiple-grid worksheet. Use HypRetrieveRange instead.
Syntax
HypRetrieve(vtSheetName)
ByVal vtSheetName 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.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Examples
Public Declare Function HypRetrieve Lib "HsAddin" (ByVal vtSheetName As Variant) As Long
Sub Example_HypRetrieve()
X=HypRetrieve(Empty)
End Sub
Public Declare Function HypRetrieve Lib "HsAddin" (ByVal vtSheetName As Variant) As Long
Sub Example_HypRetrieve()
X=HypRetrieve(Empty)
If X = 0 Then
MsgBox("Retrieve successful.")
Else
MsgBox("Retrieve failed.")
End If
End Sub