EnumRegisteredDSNs

Returns an array of the Extended Analytics Data Source Names that have been registered on the application server.

Note:

To add Data Source Names for Extended Analytics, use the Financial Management Configuration Utility. For instructions, see the Oracle Hyperion Financial Management, Fusion Edition Administrator's Guide.

Syntax

<HsvStarSchemaACM>.EnumRegisteredDSNs()

Return Value

Variant. Returns an array of Strings containing the Data Source Names. The array is 1-based.

Example

The following example populates a combo box with the Data Source Names that have been registered on an application server. The HsvStarSchemaACM instance is created on the application server by HsvSession.CreateObject. The application server is identified by the HsvSession object reference passed to SetSession.

Dim cStarSchema As HsvStarSchemaACM, vaDSNs
Set cStarSchema = cSession.CreateObject _
   ("Hyperion.HsvStarSchemaACM")
'cSession is a previously set HsvSession object
cStarSchema.SetSession cSession
vaDSNs = cStarSchema.EnumRegisteredDSNs
For i = LBound(vaDSNs) To UBound(vaDSNs)
   'cboDSNs is the name of the combo box
   cboDSNs.AddItem vaDSNs(i)
Next
'If there are registered DSNs, display the first one
If cboDSNs.ListCount > 0 Then cboDSNs.Text = cboDSNs.List(0)