Creating Workbooks

To create a workbook from within Query Designer:

Select one of the nodes in the navigation panel.
Right-click and select New, and then Workbook.
A workbook is created in the worksheet and is also displayed in the navigation panel.

Notes:

This task performs the same function as using the worksheet menu bar to create a workbook.
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 workbook.