Setting Connection Defaults

If you typically use a specific instance of Integration Server, OLAP Metadata Catalog, and Essbase Server, you can save the settings as the default. After you set default connection information, you can reuse these settings without reentering the information.

If you use multiple instances of Integration Server and OLAP Metadata Catalogs, you can also set multiple relationships and select the appropriate one to use so that you do not need to reenter the information.

  To set connection defaults:

  1. To display the Login dialog box, in the OLAP Model main window or OLAP Metaoutline main window, select Connections, then OLAP Metadata Catalog, then Connect.

  2. In the Login dialog box, click Set Login Defaults.

    The Set Login Defaults dialog box is displayed.

  3. In the Server text box, type or select the name of an Integration Server computer; for example, cypress.

  4. In the OLAP Metadata Catalog text box, type or select the name of an OLAP Metadata Catalog; for example, TBC_MD for the sample TBC database.

  5. In the Code Page drop-down list box, select the code page of the language you want to use for this Integration Services Console session.

    The code page is a portion of the locale which identifies the local language and cultural conventions such as the formatting of currency and dates and the sort order of data.

  6. In the User Name text box, type or select a user name for the OLAP Metadata Catalog.

  7. Take one of the following actions:

    • To set the connection defaults, click Set Default.

    • To save the connection information without setting the information as the default, click Add to List.

  8. In the Default Server text box, type or select the name of an Essbase Server computer; for example, cypress.

  9. In the Default User Name text box, type or select a user name for the instance of Essbase Server; for example, TBC.

  10. Click OK to return to the Login dialog box.