Opening Queries

  To open saved queries:

1. Connect to an Essbase database.

2. Select Essbase, and then Query Designer.

   Note:

   Renaming workbooks or worksheets, closing workbooks, or opening Excel windows at this point can cause synchronization problems between Query Designer and Essbase. If you must rename a workbook or worksheet, or open an Excel window, close Query Designer, disconnect from Essbase, perform the necessary Excel operation, connect to Essbase again, and perform the steps for opening a query.

3. In the navigation panel, select the active worksheet; for example, Query1.

4. Right-click and select Open Query.

5. In Query Designer Open Query, specify the location of the query file by selecting Server or Client.

6. If you select:

   • Server:

   1. Specify the application and database of the query.

   2. Select from the list of saved queries in Query Objects or enter the name in Query Name.

   • Client:

   1. To locate the query, click File System.

   2. Select the query.

   3. Click OK.

7. Click OK.

   Note:

   Query Designer can open EQD and Retrieval Wizard WIZ files, but does not support WIZ files containing multiple filters.