Data provider types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning
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