OLAPConnection (Object)

Member of:

(OLAP) Query object

Description:

Represents an OLAP Query connection file (.oce) or the database connection. The OLAPQuery connection file is used to capture and store connection information such as the connection software, the database software, and the address of your database server and your database user name for a multi-dimensional database.

Example 1:

This example shows how to connect an OLAP database using an OCE saved locally:

//Connecting to OLAP
MyConnection=ActiveDocument.Sections["OLAPQuery"].Connection
MyConnection.Open("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\Essbase.oce")
MyConnection.Username="Essbase"
MyConnection.SetPassword("Essbase")
MyConnection.Connect()

Example 2:

This example shows how to connect to the OLAP Query.oce which was included in the sample files installed with Interactive Reporting 6.x. It also sets the user name and password to "hyperion":

MyConnection=ActiveDocument.Sections["OLAPQuery"].Connection
MyConnection.Open("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\Sample OLAP Query.oce")
MyConnection.Username="hyperion"MyConnection.SetPassword("hyperion")MyConnection.Connect()

Method:

Connect(), Disconnect(), Open(Filename As String), Save(), SaveAs(Filename As String), SetPassword (Password As String)

Properties:

Read-only: Property Connected As Boolean, Property CubeName as String, Property Database as BqDatabase, Property ShowLevelProperties as Boolean

Read-write: Property Username As String