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.
You cannot change the names of named ranges from the Oracle Smart View for Office interface.
To change the names of named ranges, 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
Cascade
View Comments