Setting Data Query Optimization Options

When working with grids, you can set data query optimization options to optimize the efficiency of your data queries.

Because data queries extract values from a multidimensional database connection, it is beneficial to speed up the data query process using the optimization settings.

To set data query optimization options:

1. In a report that contains a grid, do one of the following:

   • Select Task, and then Data Query Optimization Settings.

   • Click the top left cell in the grid to select the grid, and then right-click and select Data Query Optimization Settings.

2. Select whether to suppress rows on the Database Connection Server or the Report Server.
3. Optional: Click Set to Default to use the settings defined here as the default data query optimization settings.
4. Click OK to save the settings.