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® Business Intelligence 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.

Procedure

  1. Follow the steps in the section Configuring advanced settings for specific services.
  2. For the ReportService, in the Parameter column, type RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET.
  3. In the Value column, type true.
  4. Specify the RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS and RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS settings in a similar way, and type the required values for them.
  5. Click OK.
  6. Repeat the same steps for the BatchReportService.