HypRetrieve

Describes the Oracle Smart View for Office VBA function, HypRetrieve.

Data provider types: Oracle Essbase, Planning (ad hoc only), Planning Modules (ad hoc only), Financial Consolidation and Close (ad hoc only), Tax Reporting (ad hoc only)

Description

HypRetrieve() retrieves data from the database.

Oracle 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