Creating Worksheets

To create a worksheet from within Query Designer:

Select a node in the navigation panel.
Right-click and select New, and then Worksheet.
A worksheet is created in the worksheet and is also displayed in the navigation panel. You can connect to the same database or to another one.

Notes:

This feature serves the same function as using the worksheet menu bar to create a worksheet.
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 worksheet.
Caution!
Manipulation of worksheets in VBA, such as naming worksheets or moving worksheets, may not work when Query Designer is running.