Submitting Data Ranges

Data source types: Oracle Essbase, Oracle Hyperion Planning Ad Hoc, Oracle Hyperion Financial Management Ad Hoc

You can submit contiguous and non-contiguous single cells or cell ranges.

To submit data:

1. Connect to the data source.
2. Modify data as needed.

   Alternatively, you may have opened a workbook that you received from a user who does not have Oracle Smart View for Office and modified the worksheet. Smart View cannot detect those cells as dirty, so you will need to be informed by that user which cells were modified or added.

3. Optional: To help you identify modified cells, set a cell style for dirty cells, as described in Cell Styles.
4. Select the data ranges you want to submit.

   You can select contiguous and non-contiguous single cells or cell ranges.

5. From the provider context ribbon (for example, the Planning Ad Hoc ribbon), select Submit, then Submit Data Range.

   Only cell data from selected cells is submitted. If there are dirty cells on the sheet outside the range of selected cells, the modified value is not submitted and those cells will revert back to the value that was last stored with the provider.

Note:

If you are working with multiple grids on a worksheet, see Guidelines for the Submit Data Options.