Enable Enhanced Reporting Optimization

When IBM® Cognos® Controller Microsoft Excel reports contain a significant amount of data, the Enhanced Reporting Optimization feature provides faster data transfer from the IBM Cognos Controller client to the Controller database.

When a report is run using Enhanced Reporting Optimization, Microsoft Excel sends a string to a file share on the database server. The file is inserted in the Controller database using bulk insert technology, and the report runs from that location.

Enhanced Reporting Optimization uses File Copy method. Use the File Copy method for Microsoft SQL Server databases or for Oracle databases when the Oracle server is installed on a Windows operating system.