Configuring the report and batch report services to use large worksheets

Administrators can enable support for large Microsoft Excel 2007 worksheets. When this is done, worksheets with up to 1 048 576 rows are supported.

To enable support for large worksheets, specify the advanced setting RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET for the ReportService and the BatchReportService. When the RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET setting is specified, the following settings can also be specified:

• RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS

  Specifies the number of rows to output before moving to a new worksheet.

• RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE

  Adjusts the internal memory fragment size, in rows, that the IBM® Cognos® Analytics server generates before flushing to a disk. If this value is not specified, the default is approximately 45 000 rows. This property can be useful when there are issues, such as running out of memory, when generating reports with the default value. The values might need to be lowered to allow the report to run successfully.