Setting Data Query Optimization Options

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

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

  To set data query optimization options:

  1. Open or create a report that contains a grid.

  2. Click Task, and then Data Query Optimization Settings.

    Note:

  3. To indicate the server on which you want to suppress rows, select one of the following options from the Suppress the Rows on the frame:

    • Database Connection Server

    • Report Server