Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: llopinto on 14 Jun 2019 10:54:02 AM

Title: Increasing max rows not working for Excel formatted?
Post by: llopinto on 14 Jun 2019 10:54:02 AM
in 10, I had updated the settings to allow 500k rows per worksheet with no problems.  It seems like in Analytics, it only works for Excel data, NOT excel with formatting.

Before you ask, I added these to ReportService, BatchReportService, and even the system advanced settings:

RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET = TRUE
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS = 500000
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE = 500000

Any help would be appreciated, thanks!
Text only | Text with Images