Creating Multiple-Grid Worksheets

Data source types: Oracle Essbase

To create a multiple-grid worksheet:

  1. In Excel, connect to an Oracle 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.

    Note:

    If you started with an ordinary single-grid worksheet, and want to add other grids to the sheet, see Converting Ad Hoc Worksheets to Multiple-Grid Worksheets.

  5. To create another 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 step 5 as necessary to add grids to the worksheet.

    Note:

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