Our Blog


Pentaho Reporting Export Options


Jagdeesh SS

This is a part of a series of blogs that provide quick tips and tricks to enable better usage of Pentaho. We start with this piece on improvising your Pentaho reporting export options. Have a look at the screenshot below.

Pentaho Reporting

This is a snapshot of a PRPTI report exported to excel. As you can see the date and timestamp reserve one entire row before the column headings come in. Certain consumers of the report may not want this display. This is because they want to economize real estate as well as to keep a focused span of attention on the data. Now have a look at the screenshot below.

Pentaho Reporting

As you can see the page count consumes an entire row of display, which is again inefficient usage of real estate. What if you do not want to have the date, timestamp and page count displayed?

Pentaho Reporting


Tags :

Need customized performance tuning of Pentaho dashboards? Know How


Gangadhara Boranna

There are several Performance tuning methodologies in Pentaho. However, Pentaho Dashboard designs are a combination of individual components such as reporting and analyser.

Any Pentaho Dashboard performance tuning would need to impact all such components. Two such areas are

1) Size of Data to be transferred from server to client environment (To optimize network bandwidth)
2) Rendering of Static content such as images etc.

Pentaho Dashboard

By default Tomcat is not configured to use compression when serving internal content from its webapps. Compression reduces size of all known mime types on files commonly used by the BA Server.

For the first one, we can use Tomcat gzip compression on tomcat. Compression reduces the size of transferred Data to be transferred between the client and server environment. By default tomcat is not configured to use compression when serving internal content from its webapps. Compression reduces size of all known mime types on files commonly used by the BA Server.

For the second point, Static Content can be cached. These do not change as these are related to the plugin used. Enabling caching of static content or files to speed up performance of browser has to be done for each of the plugins deployed in the BA Server.  By default caching of static content is enabled to be done only for 1 hour, you can change these setting on each plugin independently to improve performance.


Tags :