The grid represents the query results in a tabular view. You can create queries by dragging hierarchies to and from the grid. For details on how to do this see adding a hierarchy to an axis. Common analysis operations can also be performed using the grid, such as drilling, filtering, sorting, pivoting, isolating and eliminating. See the corresponding sections under "Analyzing your data" for details on how to perform these actions from the grid.
Note: only one grid per data source can be added to a report.
Adding a grid to a report
By default, when creating a new report or adding a new data source to the report a grid will be created and added to the report. The grid can be removed by clicking on the close 
button located in the title area of the grid. If the grid window has been removed you can add it by clicking the 
button on the ribbon.
Add statistical columns and rows to the grid
Extra rows and columns can be added to the grid that contain statistical information on the results.
See the display result statistics topic for more information.
Copy the contents of the grid
You can copy part of the grid contents as text to the clipboard by selecting a range of cells (through clicking and holding down your mouse) and then select Copy from the context menu (right-click). You can copy the whole grid to the clipboard by selecting the whole content of the grid (ctrl-a) and choose the copy option from the context menu or use ctrl-c.
Configure how the grid is printed and exported
To bring up the Print & Export Options dialog:
| • | Click on the arrow next to the  button and select the Print & Export Options command. |
| • | Click the button and click on the ellipsis next to the Export Settings option. |
Using the The following options can be set here. |
|
Apply level depth coloring Increase the background shade for row members as the hierarchy level increases. |
Color even rows Apply a special coloring to even rows. Note: the color used is dependent on the current look and feel chosen in the application options. It might be possible that, for the selected look and feel, the color is the same as the background color, and thus setting this option does not seem to do anything. |
Color odd rows Apply a special coloring to odd rows. Note: the color used is dependent on the current look and feel chosen in the application options. It might be possible that, for the selected look and feel, the color is the same as the background color, and thus setting this option does not seem to do anything. |
Horizontal grid lines Display horizontal lines between the grid cells. |
Vertical grid lines Display vertical lines between grid cells. |
|
If checked (default), all hierarchies on the row axis are displayed in a single column. This uses less space horizontally at the cost of more space vertically. When unchecked, the traditional nested mode is used, in which each hierarchy on the row axis is displayed in a separate column. Outline mode often provides better readable results then non-outline mode. |
|
Specifies the information to use when determining the best size for a column. The size can be based on the column header, the column data or both. |
Distribute columns evenly Adjusts the columns so that all column widths are equal after loading results. They will be set to the width of the largest column after the columns are auto-sized. |
Maximum column width The maximum width (in pixels) that a column may occupy. This value is ignored when set to 0 or lower. |
Minimum column width The minimum width (in pixels) a column must occupy. |
button on the grid ribbon will open the Grid Properties dialog as displayed below.