HypDisconnect
Describes the Oracle Smart View for Office VBA function, HypDisconnect.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypDisconnect() logs out from the data provider.
Syntax
HypDisconnect(vtSheetName, bLogoutUser)
ByVal vtSheetName As Variant
ByVal bLogoutUser As Boolean
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
bLogoutUser: Set to True to disconnect and log out from the provider session. Default value is False.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Declare Function HypDisconnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal bLogoutUser As Boolean) As Long
Sub Example_HypDisconnect()
X=HypDisconnect(Empty, True)
End Sub