Slow response to Excel query

When you refresh a query using the Excel add-in, it takes much longer than it should for the results to be returned.

For example, a query that usually takes two minutes to refresh now takes 15 minutes.

Solution

To resolve this issue, follow these steps:

  1. Log on to the Controller application server.
  2. Browse to the folder ControllerProxyServer.
    Tip: The default location is C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer
  3. Create a backup of the file web.config
  4. Open web.config in a text editor.
  5. In the <appSettings> section, add the following line:

    <add key="OptimizeExcelRefreshQuery" value="true"/>

  6. Save the file.
  7. Refresh the IIS server.
  8. Refresh the Excel query again.

The results should now be returned more quickly.