Defining the Dimension Layout for a Grid
You define the dimension layout for the grid by specifying a database connection, then dragging the available dimensions from the Point of View (POV) frame into the Rows, Columns, and Pages frames. The dimensions that are not placed in the Rows, Columns, or Pages frames are displayed in the user POV bar for that grid. You can layer multiple dimensions on a row, column, or page. For example, you might want to place the Scenario and Time dimensions on the same axis to show actual and budget data over a period of time.
Note: | If the selected database connection for the grid contains attribute dimensions, they are displayed above the Point of View frame. Like the dimensions, you can drag attribute dimensions into the Point of View frame or the Rows, Columns, or Pages frames. |
Table 9. Dimension Layout Options
Item | Description |
|---|
Grid | Grid name. This option is available only if the grid is not linked to a source grid in the repository. |
Attribute Dimensions | Type of dimension that enables analysis and is based on the attributes or qualities of the members of its base dimension. You can drag attribute dimensions from this frame into the Point of View, Pages, Rows, or Columns frames. |
Point of View | Dimensions that define the grid's point of view. The point of view identifies the data to retrieve in the grid. You can drag dimensions from this frame to the Pages, Rows, or Columns frames. |
Pages | Third axis on a grid. You can drag into this frame the dimensions to use on the Page axis from the Attribute Dimension and Point of View frames. |
Columns | Vertical display of information in a grid or table. You can drag into this frame the dimensions to use on the column. |
Rows | Horizontal display of information in a grid or table. You can drag into this frame the dimensions to use on the row axis from the Attribute Dimension and Point of View frames. |
After you define the dimension layout, you can select the members to use for each dimension. See Assigning Members to Data Rows or Columns and Assigning Members to the Page Axis.