Cloud data source types: Oracle Analytics Cloud - Essbase
On-premise data source types: Oracle Essbase
In 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 the following guidelines and limitations 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.
You cannot set a cell style for dirty cells.
You cannot enter comments.
Multiple-grid worksheets are not supported for Smart Slices.
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 the Oracle Smart View for Office Developer's Guide.
On multiple-connection multiple grid worksheets, 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.
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
These items on the Essbase ribbon are disabled:
Pivot to POV
POV
Preserve Format
Data Perspective
View Comments