Connection object, MetaDataConnection object (Sybase Only and SQL Server only)
Returns or sets the list of databases to which the .Interactive Reporting database connection file (.oce) can connect.
This example shows how to create an Interactive Reporting database connection file and set the list of databases to which the Interactive Reporting database connection file can connect:
var myCon
myCon = Application.CreateConnection()
myCon.Api =bqApiSQLNet
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.DatabaseList = "master, customer, sales"
myCon.SaveAs("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce"
//Now use this connection in a data model
ActiveDocument.Sections["SalesQuery"].DataModel.Connection.Open("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce")