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 are burst options you have?

2 Answers   HCL, IBM, TCS,


Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,


1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,


How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?

1 Answers   Polaris,


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,






What is the enterprise class platform architecture of cognos 8?

0 Answers  


Can you define cognos impromptu?

0 Answers  


What are the components required for the application tier?

1 Answers  


What is the difference between macro & Parameter

1 Answers   IBM,


What do you understand by the term 'model durability'?

0 Answers  


Explain the difference between native sql and cognos sql?

0 Answers  


Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers  


Categories