Hi Gurus,
I have a quick question on the formatting of a report, i am trying to export the report to Excel 2007 Data and the numbers are getting displayed in Text format instead of Number but when i try to import the data to Excel 2007 everything displays as expected. I have this requirement as Excel 2007 has a limitation to display 65,000 rows per page.
Any valuable suggestions and inputs would be of great help...
Thanks.
Hello v2k4u,
You can set the advanced parameter RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS to a value of 1,048,576 and then use Excel 2007 as your output format.
-Cognos810
Hi,
Can you please specify where exactly i can set this advanced parameter RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS to a value of 1,048,576 ?
Thanks.
-Logon as an Administrator
-Go to Launch > IBM Cognos Administration
-Click on Configuration tab
-Click on Dispatchers and Services
-At top right you will see a series of icons, click on the icon for "Set Properties - Configuration". See document attached for image.
-Next, click on Settings tab
-Click on "Edit" for Advanced Settings for the Environment Category. See document attached for image.
-Click on OK
-Click on OK again.
I feel obligated to point out that exporting that many rows to Excel usually means you are not really making the best use of Cognos.
But what do I know.