Creating Multiple-Grid Worksheets

  To create a multiple-grid worksheet:

1. In Excel, connect to an Essbase data source.

2. From any location in the worksheet, select a range of cells (You must select a range rather than only one cell).

3. From the Smart View Panel, right click an application, and then select Ad Hoc Analysis.

4. When prompted to change the worksheet to support multiple grids, select Yes.

5. To create a second grid on the worksheet:

   1. Select a different range of cells.

   2. From the Smart View Panel, right click an application, and then select Ad Hoc Analysis.

6. Repeat step 5 as necessary to add grids to the worksheet.