Setting Grid Rows and Columns

Before you enter data into a Financial Management application, you must select the dimensions and dimension member lists to display on the rows and columns of the data grid. Any dimensions that you did not include in the grid rows and columns are called slicer dimensions. You should select a member for each slicer dimension.

You can select whether to display data, calculation status, process level, and metadata labels or descriptions in grids. See Setting Display Options .

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. Select Administration, then Manage Documents, or click Manage Documents Manage Documents button and select Data Grid.

  2. Click New Data Grid and click Grid Settings button Grid Settings.

  3. From Layout, select row and column dimensions from Page Dimensions, and use the arrows to move them to Row and Column:

    • To move a dimension to Column Dimensions, click Move Right button.

    • To move a dimension to Row Dimensions, click Move Down button.

    • To return a dimension to Page Dimensions, click Move Left button.

    • To move dimensions between Row and Column, use the arrow keys.

    • To change the order of row or column dimensions, click the Up or Down arrow keys.

  4. Click OK.