Wednesday, 11 June 2014

COGNOS: INCREASING THE NUMBER OF ROWS IN MS-EXCEL OUTPUT

Cognos allow us to view the report output in different format including MS-Excel 2007.

By default Cognos allow us to display 65000 rows in MS-Excel, but this can be increased

up to 1048576 rows. We can achieve this by doing some changes at Cognos administrator

level. Here are the simple steps

- Open Cognos Administrator
- Select System under Status tab
- Click on BatchReportService. Click on Set Property and set the following variables


RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - true
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - 1048576

- Run the report in MS-Excel format and you will be able to display upto 1048576 records
in a sheet.


Posted by at
Labels:

8 comments:

  1. Anonymous14 June 2014 at 21:44

    Thanks...What is the maximum limit?

    ReplyDelete
  2. Lincoln3511 January 2017 at 10:46

    Hi,

    I have done everything as explained here and in all other pages, but it has no effect on Excel 2007 FORMAT. Services have been restarted. In Excel 2007 DATA it seems to work fine.

    Any idea what could be wrong?

    Same for RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL. I do not see the effect of this setting.

    Best regards
    Radek

    ReplyDelete
  3. Anonymous23 January 2017 at 01:48

    Thank you. This worked fine for me. However, the changes have to be made to both reportservice and batchreportservice. This Cognos KB article is helpful too: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_config_lgwrkst_ex.html

    ReplyDelete
  4. Unknown18 March 2019 at 06:27

    what about cognos 11?

    ReplyDelete
  5. Anonymous2 December 2019 at 10:44

    I cannot thank lemeridian funding service enough and letting people know how grateful I am for all the assistance that you and your team staff have provided and I look forward to recommending friends and family should they need financial advice or assistance @ 1,9% Rate for Business Loan .Via Contact : . lfdsloans@lemeridianfds.com / lfdsloans@outlook.com. WhatsApp...+ 19893943740. Keep up the great work.
    Thanks, Busarakham.

    ReplyDelete
  6. Priyanka26 December 2019 at 11:57

    i got an error on administrator page.

    CM-REQ-4144 Content Manager expected to find an integer value in element "maxObjects" but found "NaN" instead.
    Details | Retry | Hide this message. can anyone help please

    ReplyDelete
  7. Anonymous28 December 2024 at 01:56

    Cool and I have a tremendous offer: What Renovations Increase The Value Of A Home best home renovation

    ReplyDelete

Subscribe to: Post Comments (Atom)