CODEWITHSUNDEEP
reporting-servicesreportpentaho
Mario
Mario

Reputation: 2453

pentaho user console excel output

I am trying to get excel report output from 'pentaho user console'. I created a cube in schema workbench and uploaded the cube and creating report out of it.

My excel report says "Unable to render report table. The table may not contain more than 10000 columns or more than 10000 rows."

My report has around 40000 rows. How can my excel report give me more than 10000 rows?

Can we change the row limit to a greater number?

Thank you!

Upvotes: 1

Views: 1937

Answers (2)

ricardodiaz
ricardodiaz

Reputation: 11

You have to change in the analyzer.properties in the Line 18

renderer.export.max.rows=10000 by the value that you want

Upvotes: 1

Codek
Codek

Reputation: 5164

Are you using Analyzer? Thats the only place I can think where you would see this limit. In which case you should take this up with Pentaho Support, as that means you must have an EE contract.

One thing to bear in mind though, OLAP tools e.g. analyzer/saiku/jpivot based on mondrian are not the place to be generating such large data exports anyway. Possibly it should be reporting, or if very large perhaps just a transformation exposed via an xaction. This is because there'll be a lot of effort in the reporting or analysis engine to export such a large amount of data - whereas in an ETL engine which is optimised for that it'll be much quicker.

Upvotes: 1

Related Questions