Hi All,
i use cognos report studio v10.x, i would like to know what is the max possible export file size or export max row number for each type of export format:
i only know that with the new 10 version of cognos report studio, it is possible export report with over 1 million row in excel file 2007 format (... but how many columns are possible use in this report ?.... cognos easily support all this huge data export ?)
I need to know what is the max number of row that is possible to export (or max Mb of file exported) if using other format:
CSV, pdf, xml, html ...
There are some limitation in the performance ? (...i.e. too much time to complete the export)
Export perfomance decrease in proportion with the increase of the number of row exported ?
Tanks and regards
Supporting large worksheets in Microsoft Excel
Administrators provide support to users that need to use large Microsoft Excel 2007 worksheets by setting the advanced server property, RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET, to a value of true. This enables the large worksheets. You must set this property for the ReportService and the BatchReportService.
When RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET is enabled the large worksheet property supports worksheets up to 1 048 576 rows and the following two properties can then be used:
Parameter Description
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS Use this parameter to specify the number of rows to output before moving to a new worksheet.
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE Use this parameter to adjust 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, then the default value is approximately 45 000 rows. You can use this property when there an issue generating reports with the default value, such as running out of memory. In this situation, you may be required to lower the value to allow the report to run successfully.
Configuring report and batch report services to use large worksheets
Set the advanced server property, RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET, to a value of true to enable large worksheets. You must set this property for the ReportService and the BatchReportService.
http://pic.dhe.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cra.10.1.1.doc%2Fc_lrg_wrksht_msexc.html
Hello,
Has anyone implemented RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS and RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE? Are there any disadvantages and/or known issues? We are on Windows 2008 servers, 10.1.1 FP1. Thank you in advance!