Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  


What is the information present in the cognos configuration file?

0 Answers  


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

0 Answers  


---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,


What is Metrics designer?

0 Answers  


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

4 Answers   HCL,


What are the types of studio present in Cognos?

0 Answers  


how u create security to reports ????

10 Answers   iFlex, iGate,


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

0 Answers   IBM,


How do we drill through from a powerplay cube to reportnet?\

0 Answers   IBM,


What is Index?

2 Answers  


what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,


Categories