Setting Data Grid Rows and Columns

Before you enter data into a Oracle Hyperion Financial Management application, you must select the dimensions and dimension member lists to display on the POV, and rows and columns of the data grid. You can drag and drop dimensions to and from the POV bar and the grid rows and columns.

If your administrator has defined dynamic POV member lists, you can use them to quickly populate rows and columns with valid members for the selected dimension. In the Member Selection dialog box, the valid dynamic POV member lists for the selected dimension are displayed with an @POV suffix at the bottom of the dialog box.

When you exit a grid, the user point of view is updated for all dimensions except the values in the dimensions defined in the rows and columns. Although the values for rows and columns are stored in the grid settings, these values are not used to update the User Point of View when you exit the grid.

To set grid rows and columns:

1. From the Document Manager, click New, and then Data Grid, or select Actions, then New, and then Data Grid.
2. To select the row and column dimensions to display on the grid, drag the dimensions from the top POV to the rows and columns as needed.
3. Click the dimensions on the rows, columns, or POV to select members or a member list.
4. Optional: Select the POV options button to select and change POV options.
5. Optional: Select the Column options button next to a column, or Row options button next to a row to select and change column or row options.
6. Optional: To change the order of row or column dimensions, select the Down arrow next to the Column options or Row options button, and select Reorder Dimensions. Select the dimensions and use the arrow keys to change the order, and click OK.
7. Optional: To view the data grid, click Grid Viewer, or select Actions, and then Grid Viewer.

   Tip:

   To return to the Grid Designer, click Grid Designer, or select Actions, and then Grid Designer.

8. Click Save to save the grid layout.