Data source types: 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 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 he performed only on that grid.
You cannot set a cell style for dirty cells.
You cannot enter comments.
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