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 |
How do I remove the hyperlink from the drill through report?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
difference between boxtype and visiable
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Define report item?
what is Galaxy schema??
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
what is the difference between rollup aggregation and aggregation ?
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?