Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Monday, 21 July 2014

Tip : Export JPivot output to excel in Pentaho 5.x version. (By default export to Excel is disabled in 5.x server)

Hi Readers,

This tip is useful to enable the "Print" property of JPivot output to Export into Excel sheet.

By default in pentaho 5.x version servers it is disabled.

Un comment below code in plugin.spring.xml file

    <bean id="Print" class="org.pentaho.jpivot.proxies.ProxyPrintServlet"/>

Location of the file is :

<YourDrivePath>/biserver-ce/pentaho-solutions/system/pentaho-jpivot-plugin

NOTE : Once you enable the code, stop the BI server and start again. [B'z it is a configuration file and changes will be affected iff you restart the server.]

Test: In the xml file it was suggested to replace with fop-0.20.5, but I didn't do it instead just uncommented the code and tested which is worked as expected.. If you still unable to get export work , you might have to replace the specified jar file.



:-)