Creating Multiple-Grid Worksheets

Data source types: Essbase

  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.