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 only for one grid at a time. If you try to submit data for more than one grid or for the entire worksheet, no data is submitted.
You cannot set a cell style for dirty cells.
You cannot enter comments.
These buttons on the Essbase ribbon are disabled:
Undo
Redo
Pivot to POV
POV