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
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 |
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 |
----------------What is meant by DSS?
what are the enhancements in cognos reportnet ?
How to Reset Pagenumbers in one report.
What is Crossproduct?
What are the types of security?
Can you define snapshot?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
What are types of batch available in cognos?
How do we create row level security in cognos8?
How do you test the performance of a report?
What is a Pivot?
what is the difference between aggregation and role up aggregation ?