Our Pentaho BI 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

Crosstabs 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. Crosstabs 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 crosstabs are still an experimental feature, and as such are not up to par with their counterparts in …

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.