Monday, October 12, 2015

Landing page in Pentaho User Console

Problem: After login to Pentaho User Console, you need to redirected to a customized page instead of Home page of Pentaho. (In this case i have created my own page)

Go to /tomcat/webapps/pentaho/index.jsp and change

<META HTTP-EQUIV="refresh" CONTENT="0;URL=./Home">
<META HTTP-EQUIV="refresh" CONTENT="0;URL=/pentaho/content/pentaho-cdf/RenderXCDF?solution=mydashboard&path=/company&action=homedashboard.xcdf&template=companyview">


Monday, September 28, 2015

Installing Pentaho BI server on Amazon EC2

Steps to install Pentaho BI server on Amazon EC2 box:

  1. Bring up amazon ec2 box
  2. Download pentaho community latest version from
    At the time of writing this blog, Pentaho 5.3 and we download it using this command

  3. Unzip the folder 

Pentaho: Moving from http to https

Reference :

Pentaho User Console: Change default port

Reference :

Having ALL data with muli select


Friday, July 24, 2015

Sparkl : Creating Effective Dashboards on Pentaho

With the introduction of Sparkl pluign which works with Pentaho 5 and above, it has become very easy to create Dashboards which can be quickly created.

To understand what sparkl is, you should consider reading :

How to work with sparkl :

Getting some useful tips to create your first production dashboard:

If you wish to check how to debug the kettle endpoints:

Documentation to develop plugin:

Thursday, July 2, 2015

Creating Pentaho report using Rest API


Use of dynamic variables to form URL

Sunday, June 21, 2015

How to enable compression on Tomcat?

Problem Statement: My web page is loading very slow.
Solution: Check out the reason for the same on Pagespeed insights tool from google here

The most probable solution which is offered today for Mobile and Desktop is to enable compression.
And if you are using Tomcat then this is a cake wake.

Here is how to enable compression on Tomcat:
1. Go to the path where you have installed Tomcat i.e cd tomcat/conf
2. Open server.xml and search for the pattern :
<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1"
               redirectPort="8443" />

3. Change this to :
<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1"
               redirectPort="8443" />

4. That's it. Now restart tomcat and check out the page speed again using google tool to analyse it.

I am working on Pentaho systems which uses tomcat server and got the solution from

Monday, June 1, 2015

Hide files in Pentaho User Console

Hello Friends,

There are situations when you need to hide the files generated by Pentaho.
Pentaho by default generates three types of files to be displayed in Pentaho User console:

.cda - The data access file, which is of no use to business user
.cdfde - Framework File, again of no use to be business user
.wcdf - Dashboard file, which you most likely need to keep
Use case: When you give a multiple dashboards to business user, he should be able to see only the dashboard files. Something like the image below:

To achieve this go as admin -> browse files -> select a file -> click on properties -> hidden

To show the hidden files, go as admin, click on Menu-> show hidden files as show:


Saturday, May 30, 2015

Welcome to the world of Analytics

Hello World,

We are out here to explore and learn new things in the world of Analytics.
To start with we have chosen to work on Pentaho, an open source business intelligence tools which is a life saver for many companies struggling with cost. For more details on Pentaho you can click here.

Gradually we will be covering some data mining and machine learning problems as well