Data source types: all
You can update the data (any type) in the data source by submitting changed data from ad hoc grids and data forms. Changes made while you are unconnected can be submitted after you reconnect.
In free-form mode, you must refresh the grid before modifying the data.
If you are submitting from data forms:
In Planning, Financial Management or Hyperion Enterprise data forms, you can lock any cell or range of cells to protect the data until the data is refreshed or submitted. Locking the cell does not lock the actual data cube in Financial Management, 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 data form definition. This may happen if data 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 data form definition are saved. This applies to both cells and supporting detail changes, and also applies to both online and offline modes.
Caution! | If you intend to modify member names, submit any unsaved data beforehand. If you modify member names, you trigger free-form mode and must refresh before submitting data. Because refreshing replaces data in the worksheet with data from the data source, modifications are lost before you submit them. |
To submit data: