Creating Multiple-Grid Worksheets

Data source types: Oracle Essbase, Oracle Analytics Cloud - 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.

    Note:

    Multiple-grid worksheets are not supported for Smart Slices.

  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.

    Note:

    Starting in Oracle Smart View for Office11.1.2.5.400, the creation of multiple-grid worksheets using refresh is no longer supported.