pentaho user console excel output

Question

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!

score 1 · Accepted Answer · answered Mar 13 '13 at 09:41

1

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.

answered Mar 13 '13 at 09:41

Codek

5,114
3
24
38

I am using Analyzer Report. I am unable to see more than 10000 rows in Excel format. – Mario Mar 13 '13 at 13:51
I just exported in CSV which allowed me to download ~75k rows. Not in regular Excel format though – Mario Mar 13 '13 at 14:37
do you know the maximum size I can get as an Excel output? – Mario Mar 13 '13 at 17:50
Found that the default size of 10000 can be changed. – Mario Mar 14 '13 at 21:15
Great - Post the answer here then so you can help others! – Codek Mar 15 '13 at 06:33

score 1 · Answer 2 · answered Aug 29 '13 at 22:06

1

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

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

answered Aug 29 '13 at 22:06

ricardodiaz

11
1

pentaho user console excel output

2 Answers2