Creating Queries

  To define a query for each worksheet:

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 creating a query.

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

4. Right-click and select New, and then Query.

   Essbase populates the layout panel with a default layout for a selected database.