Submitting Data

Data source types: all

You can update the data (any type) in the data source by submitting changed data from ad hoc grids and forms. You can submit the changes made while you are unconnected after you reconnect.

For data sources other than Essbase, you must refresh the grid before modifying the data when you are in free-form mode. For Essbase connections, you can submit data without first refreshing. See Retrieving Data.

Note:

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.

If you are submitting data from forms:

In Planning, Financial Management, or Hyperion Enterprise forms, you can lock any cell or range of cells to protect the data until the data is refreshed or submitted. In Financial Management, locking the cell does not lock the actual data cube but only the cell in the form. When the data is refreshed or submitted, the cell is no longer locked.
Some cells may no longer exist in the form definition. This behavior may happen if form definition or access privileges have changed, or if rows or columns are suppressed. In these cases, only writable cells that exist in the new form definition are saved. This behavior applies to both cells and supporting detail changes, and also applies to both online and offline modes.

To submit data:

Connect to the data source. If you are using Essbase, skip to step 3. Otherwise, continue with step 2.
If you are working in free-form mode, from any ribbon, select Refresh.
Modify data as needed.
From any ribbon, select Submit Data.