we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

Answers were Sorted based on User's Feedback



we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacit..

Answer / shivani nadkarni

What i can think of is related more with the admin setup for Cognos.
Got to Cognos Administration -> System->Status
Under BatchReportService add the below parameters:
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - <true>
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - <increase the row limit here>

Is This Answer Correct ?    0 Yes 0 No

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacit..

Answer / shivani

In continuation to my admin related change above I figured that using Excel 2007 can address this issue too. The limit has been increased on 2007 and all versions above it.
https://www.ibm.com/support/pages/ibm-cognos-icm-excel-row-limitation

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is logs in cognos

1 Answers   HCL,


write a query to display the third record from the employee table?

4 Answers   HCL,


What is Performance Tunning Test?

2 Answers   IBM,


-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,


What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers  






how can you create a project creation

0 Answers   HSBC,


what are the special features in cognos reportnet?

0 Answers   IBM,


How do I remove the hyperlink from the drill through report?

2 Answers   Misys,


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,


How many reports did you create in your project?

3 Answers   IBM,


Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,


------------- How to identify the Revenue Column in Report?

0 Answers  


Categories