Enabling a larger worksheet size for Excel 2007
Let's say that you have built a report that primarily is a data extract. It produces more than 65,000 rows. When users run it in Excel 2007, it is spread across multiple sheets though Excel 2007 supports over a billion rows. Let's see how to fix by changing server settings.
Getting ready
You require admin rights for this so you can change service settings.
How to do it...
In this recipe we will see how to enable a larger Excel 2007 worksheet by changing IBM Cognos BI server settings.
Open Cognos Administration from Connection Portal and go to Configuration | Dispatcher and Services.
Click on the dispatcher and it should show you all services.
Go to the Properties pane of Report Service and open Advanced Settings.
Define a new parameter called
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEETand set its value as TRUE.
Do the same for the Batch report service. Restart the services.
How it works...
By defining this parameter, we enable Cognos to produce large worksheets...
