HypGetSharedConnectionsURL
Data source types: Essbase, Planning, Financial Management, Hyperion Enterprise
HypGetSharedConnectionsURL() returns the Shared Connections URL to be used. (also shown in the Options dialog box).
HypGetSharedConnectionsURL (vtSharedConnURL As Variant)
ByRef vtSharedConnURL As Variant
vtSharedConnURL: the output parameter that contains the Oracle's Hyperion® Shared Services URL, if successful.
Returns 0 if successful; otherwise, returns the appropriate error code.
Declare Function HypGetSharedConnectionsURL Lib "HsAddin" (ByRef vtSharedConnURL As Variant) As Long
Sub SubHypGetURL()
Dim lRet As Long
Dim conn As Variant
lRet = HypGetSharedConnectionsURL(conn)
MsgBox (lRet)
MsgBox (conn)
End Sub