Control data compression for data

Automatic data compression is one way that Planning Analytics for Microsoft Excel decreases processing time for large data transfers from the IBM® Cognos® Analytics server.

Data compression should be turned on under normal circumstances.

Although compression is turned on by default, you can turn it off by setting the UseGzipCompression property to false in the CommManagerSettings.xml file. By default, the file is located in the Office Connection directory, C:\Documents and Settings\[user name]\Local Settings\Application Data\Cognos\Office Connection or C:\Users\[user name]\AppData\Local\Cognos\Office Connection.

Turn compression off if you need to run tests or perform troubleshooting. To turn compression off, set the following attribute:

<setting name="UseGzipCompression">False</setting>

To turn compression on, set the following attribute:

<setting name="UseGzipCompression">True</setting>

Compression is turned on automatically when you change from RawXML format to CSV format for lists. The global property is not changed, which means that if you turned compression off, that setting is retained for other types of data transfer.

For example, if you have compression turned off and you create a new exploration after making a CSV list request, then your exploration data is still uncompressed.