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

what is differences between the group span and levelspan

1 Answers  


Create 12 columns for months by writing single case statement?

1 Answers   Wipro,


Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  


what are determinants?

4 Answers   College School Exams Tests, IBM,


What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers  


How can I schedule reports in cognos?

0 Answers  


hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  


Explain difference between powerplay transformer and power play reports?

0 Answers  


Can you define report item?

0 Answers  


Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)

7 Answers   AIG, IBM,


Is it possible to join multiple Databases in a Catalog?

0 Answers  


It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  


Categories