Adding a New Grid

When you create a report, you must add a grid.

To add a new grid:

1. Do one of the following:

   • Click , and then position the grid in the Body section in the Report Designer.

   • Select Insert, then Grid, and then position the grid in the Body section in the Report Designer.

   • In the Body section in the Report Designer, click , and then select Grid.

2. In Database Connection Properties, select an existing database connection, or click New Connection to create a new database connection.
3. In Dimension Layout, drag dimensions from Attribute Dimension (if they exist) and from Point of View, into Page, Rows, and Columns, and then click OK.

   You can place multiple dimensions into Page, Rows, and Columns. The dimensions that are not placed in Pages, Rows, or Columns are displayed in the user point of view bar located at the top of the Report Designer for the grid.

   You can layer multiple dimensions in 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.

When you add a new grid, the system assigns a default name to the grid. The default name assigned is Gridn, where n is a system-assigned identification number. For example, if you save a grid that is the sixth system-named grid saved in the report, the default name is Grid6. You can rename the grid in Grid Properties.

The system uses the grid name when a function or chart references the grid. For example, if you design a chart to graphically display the data from a grid, the chart properties must reference the grid by its name.