Creating Data Grids

You use data grids to enter, view, or manually edit data in Oracle Hyperion Financial Management applications. After you enter or edit the data, you can calculate the data, translate the data to other currencies, or consolidate the data. You can view data status, calculation status, process levels, line item detail, and destination and source transactions. In addition, you can lock and unlock data, run allocations, and run entity transaction detail reports.

You can display data, calculation status, or process level in data grids. If journals are posted to the selected intersection in the grid, you can display all journal transactions against the cell. You can store text and line item detail for cells in the grid.

Dimensions are displayed in rows and columns on a data grid. You can save the grid settings and reopen the grid later instead of resetting the rows and columns.

From a data grid, you can select menu commands to calculate, translate, and consolidate the data. If a task is not applicable for a cell, the menu command is not available.

To create data grids:

  1. From the Document Manager, click New, and then Data Grid, or select Actions, then New, and then Data Grid.
  2. Set the grid rows and columns. See Setting Data Grid Rows and Columns.
  3. Set the grid display options. See Setting Grid Display Options.