Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management, Oracle Business Intelligence Enterprise Edition
Description
For on-premises data sources, HypUIConnect() prompts the user with the Connect to Data Source dialog box when the user name and password are not provided. It does not prompt if they are already provided.
For form-based authentication (for example, for cloud data sources), you must use the HypUIConnect VBA function to connect to an existing private connection. HypUIConnect() always prompts for authentication where the user must provide the user name, password, and domain to log in.
Syntax
HypUIConnect Lib (vtSheetName, vtUserName, vtPassword, vtFriendlyName)
ByVal vtSheetName As Variant
ByVal vtUserName As Variant
ByVal vtPassword As Variant
ByVal vtFriendlyName 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.
vtUserName: A valid user name
vtPassword: The password for this user
vtFriendlyName: The connection name of the data provider
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare PtrSafe Function HypUIConnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtUserName As Variant, ByVal vtPassword As Variant, ByVal vtFriendlyName As Variant) As Long HypUIConnect(Empty, UserName, Password, "My Connection")