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?
- 2 Answers
- 1961 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
how can you get the errors in job? when loops are araised we get error?
i was asked what are the caluclations done by you in your report? plz give reply
why u need to publish the package?
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
What is the difference between List and Cross tab? Could some on explain with an example..
What is the use of cognos decision stream?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
what is Associated grouping? and how it works in cognos impromptu?
What is a Transformer?
What is meant by alternate drill down with ex?
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
Teradata 
