1. Working with Oracle Smart View for Office
  2. Ad Hoc Analysis
  3. Working with Multiple Grids on a Worksheet
  4. About Multiple Grids on a Worksheet

About Multiple Grids on a Worksheet

Data source types: Oracle Essbase

In Oracle Essbase, you can create multiple grids on one worksheet. These grids can be connected to the same data source or to different Essbase data sources. You can retrieve data in these grids and shift them on the worksheet.

Note:

If you are using an Oracle Enterprise Performance Management Cloud data source to create multiple ad hoc grids on a sheet, see Working with Multiple-Grid Worksheets in EPM Cloud.

Guidelines and Best Practices

Note the following guidelines, best practices, and limitations while working in worksheets that support multiple grids:

  • You can submit data for only one grid at a time.

    If you try to submit data for more than one grid at a time—that is, if you have selected cell ranges in more than one grid—the first range returned by Excel will be used to determine the selected grid and the submit will be performed only on that grid.

  • If Preserve Formulas and Comments in ad hoc operations (except pivot and undo) is selected, you can preserve formulas on the sheet using the Undo option on the right-click Smart View context menu from within the grid. This option is only supported after a refresh has been performed once formulas are added to the sheet, and only for one undo action. This option is only supported for one undo action. The Undo option on the Smart View ribbon is not enabled for multiple-grid sheets. See Preserving Excel Formulas Within and Outside of Essbase Ad Hoc Grids.

  • Multiple-grid worksheets are not supported for Smart Slices.

  • As a best practice, do not use Microsoft Excel's Name Manager or Name Box to rename named ranges. Instead, use one of the following methods to rename named ranges:

    • Use the Rename Range command in the Document Contents pane of the Smart View Panel. See Renaming Ranges on Multiple-Grid Worksheets

    • Use the VBA function, HypModifyRangeGridName, described in Oracle Smart View for Office Developer's Guide.

  • On multiple-connection multiple grid worksheets, as a best practice, ensure that there is enough space between grids to accommodate pivot and zoom operations on the individual grids. A loss of metadata may occur on sheets with three or more database connections and where grids are placed too close together.

  • As a best practice to ensure that you are refreshing the desired range, use the Document Contents pane to first select the range, and then click the Refresh link in the pane. After refresh, select the range again from Document Contents to highlight the updated range.

  • These items on the Smart View ribbon are disabled:

    • Undo

    • Redo

    Instead, to access the Undo and Redo commands when working with a multiple-grid sheet, ensure that your cursor is in the affected grid. As a best practice, use the Document Contents pane to ensure that you have selected the correct grid. Then, right-click and select Smart View from the context menu, and then select Undo or Redo, as required.

  • These items on the Essbase ribbon are disabled:

    • Pivot to POV

    • POV

    • Preserve Format

    • Data Perspective

    • View Comments