Cloud data provider types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypListApplications() gets the list of applications and their descriptions for the requested provider.
Syntax
HypListApplications (vtURL, vtServerName, vtUserName, vtPassword, vtApplications, vtAppsDescriptions)
ByVal vtURL As Variant
ByVal vtServerName As Variant
ByVal vtUserName As Variant
ByVal vtPassword As Variant
ByRef vtApplications As Variant
ByRef vtAppsDescriptions As Variant
Parameters
vtURL: URL of the provider
vtServerName: Server name
vtUserName: User name
vtPassword: Password
vtApplications: List of applications
vtAppsDescriptions: List of application descriptions
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
This example combines the HypListApplications and HypListDatabases functions.
Sub test() Dim url As Variant Dim srv As Variant Dim SSO As Variant Dim uname As Variant Dim pswd As Variant Dim app As Variant Dim Applist As Variant Dim AppDescList As Variant Dim AppCubeList As Variant 'Essbase url = "http://<server>:<port>/aps/SmartView" app = "Sample" srv = "EssbaseCluster-1" uname = "admin" pswd = "password" ss = HypConnect("Sheet1", "admin", "ppp", "Conn123") ss = HypListApplications(url, srv, uname, pswd, Applist, AppDescList) ss = HypListDatabases(url, srv, uname, pswd, app, AppCubeList) MsgBox (ss) End Sub