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?
Answer Posted / 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 |
Post New Answer View All Answers
what are the filters in framework manager and report studio?
What is the difference between ‘macro’ and ‘prompt?
Name the types of report?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what is the main advantage of impromptu over cognos reportnet?
What is the difference between Standard and Metrics folder?
Why need staging area database for dwh?
what is the procedure for scheduling conditional rendering?
Define dimensions?
what do u mean by bridge group? where we r using this one?
What are shortcuts? Where it can be used? What are the advantages?
Can you define a catalog and types of catalogs in cognos?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What do you mean by drill through report?
Mention the difference between ‘macros’ and ‘prompt’?