Connecting to Multiple Databases from Query Designer

  To connect to multiple databases from Query Designer:

1. Log on to Essbase and connect to the server to access.

2. Select Essbase, and then Query Designer.

3. Select [Book1]Sheet1, right-click, and select Connect.

   The Essbase System Login dialog box is displayed.

   Note:

   The book may be a number other than 1. For example, it may be [Book5], if four worksheets are open.

4. Enter your password, and then click OK.

5. Select Sample Basic, and then click OK.

6. Select [Book1]Sheet2 (or Sheet3), right-click, and select Connect.

   The Essbase System Login dialog box is displayed.

7. Enter your password, and then click OK.

8. Select Samppart Company, and then click OK.

   Note:

   You are restricted to one connection per worksheet. The connection information is displayed in the query information panel of the Query Designer only when you open or create a query.

9. To create a query based on Sample Basic, select [Book1]Sheet1, then right click and select New, and then Query .

10. To create a query based on Samppart Company, select [Book1]Sheet2, then right-click and select New, and then Query.

11. To open a query, right click and select Open Query.