Creating an OLAP Connection File

  To create an OLAP connection file:

1. Select Tools, then Connection, and then Create.

   The Database Connection Wizard is displayed.

2. Select the connection software used to connect to the OLAP database server from the drop-down box.

3. Select the OLAP database server from the drop-down box and click Next.

   Depending on the database you select in this field, you may have to specify a password to connect to the database. Enter your name, password, and host address information.

   The sequence of dialog boxes that are displayed depend on the multidimensional database server to which you are connecting. The following sections provide connection information for these multidimensional databases:

   • Connecting to Essbase or DB2 OLAP

   • Connecting to an OLE DB Provider

   • Connecting to Essbase (CubeQuery only)