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 |
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What is the information present in the cognos configuration file?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
---------- Purpose of Factless Facttable?
What is Metrics designer?
write a query to display the third record from the employee table?
What are the types of studio present in Cognos?
how u create security to reports ????
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
How do we drill through from a powerplay cube to reportnet?\
What is Index?
what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??