Entering or Editing Data

You use data grids to enter data manually into input accounts for base entities in Oracle Hyperion Financial Management applications. Values for parent-level members are aggregrated from the children of the parent-level members. In some cases, data for base-level members is calculated. For example, the Salaries member might be a base-level member calculated based on headcount and salary rate.

Calculated and consolidated accounts do not accept data entry, because the values they contain come from other sources. For example, if a company called USA East has three dependents, you enter values into the dependent entities. After you consolidate, the value in USA East is the total of the values in its three dependents.

When you save data, Financial Management automatically calculates totals for the parent members of the dimension hierarchy.

You can enter "NODATA" in a cell to clear data from the database. For example, you might enter data into an incorrect intersection and want to clear the data without entering zeros in the database.

After you enter or edit data, you can submit the changes to the database, and refresh the grid with the most recent data from the database.

To enter or edit data:

  1. Open a data grid.
  2. Double-click the cell in which to enter or edit data.
  3. Enter a value in the cell and press Enter or Tab.
  4. Repeat the steps until you have entered or edited all the necessary data.
  5. Click Submit Data to save the data.

    To discard the unsaved data, click Reset Data.