Our Pentaho BI Blog


Manikandan Anbalagan

GrayMatter‘s experts address customers’ Pentaho Reporting related needs and challenges on a daily basis. Starting from data integration using Pentaho Data Integration to dashboarding using dashboard designer, reporting using report designer, best-in-class custom components, we have done it all for 200+ projects around the globe. I am going to focus on reporting in this blog. Following are some reporting requirements that run into issues with Pentaho, did you face these? Including date as part of report file name Embedding chart …

Read full Blog.



Jagdeesh SS

Pentaho Reporting Export Options

October 13, 2016   Posted By


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. 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 …

Read full Blog.



Gangadhara Boranna

Clustering means that 2 or more instances of Pentaho share a common repository. Pentaho 5.0.X now uses the Jackrabbit Content Repository (JCR) for the BA Repository. Pentaho reporting related content, for instance, about reports that you create, examples we provide, report scheduling data, and audit data in the BA Repository. The BA Repository resides on the database that you installed. The BA Repository consists of three repositories: Jackrabbit, Quartz, and Hibernate.   – Jackrabbit contains the solution repository, examples, security …

Read full Blog.



Sandeep Kemparaju

We are looking at a transformation designed to use insert/update step to perform data load on the target table. Pentaho Kettle step Insert/Update works as follows Let us take an example of loading a target table. Assume that there is a daily load of 100k records into a target table with 10 million records and every incoming row from the source table looks up against all the 10 million records in the target table. This process continues for all the …

Read full Blog.



Gangadhara Boranna

We strongly encourage you to move to Pentaho’s latest environment that provides advanced Pentaho Migration features. Listed below are 6 top reasons why Pentaho 5.0 could be your ideal solution. 1. Integrated Administration in PUC & Merge of enterprise console into Pentaho user console This aspect gives a completely fresh look to the user console. The Pentaho 5.0 version has improvised navigation through perspectives and home page with integrated administration. The user console also simplifies the permission control mechanism using …

Read full Blog.



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.



Gangadhara Boranna

Cross-tabs have been on the horizon for several years now. They lived a happy, undisturbed life along with the unicorns and gnomes guarding the pot of gold at the end of the rainbow. In Pentaho Implementation, Cross-tabs are an easy and relatively easy way to visualize tabular data along two or more axis. They are an indispensable part of a modern Pentaho Reporting engine. Although cross-tabs are still an experimental feature, and as such are not up to par with …

Read full Blog.



Suresh Narayanappa

Pentaho and Big Data

April 21, 2014   Posted By


Pentaho Big Data Analytics provides open source reporting, data mining, and analysis, workflow and dashboard capabilities. The company’s CEO, Quentin Gallivant, made a few predictions relating to Big Data for 2014. In my next blog sometime in May am going to share a unique use case for a Big Data implementation. The “power curve” of Pentaho Big Data Analytics will be created by the demand among business users for blending of data. Some clients of Pentaho recently elaborated on their …

Read full Blog.



Suresh Narayanappa

Pentaho Corporation recently announced the immediate availability of its Open Source Pentaho Community Edition 5.0 (Pentaho CDE). It is the latest version of business analytics and open source data integration platform. The launch event also included the Pentaho Marketplace, where members of the community can download and explore all available plug ins developed by the Pentaho Community. It has extended the capabilities of the open source platform and permits community members to work together, share feedback and submit or create …

Read full Blog.