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 http://community.pentaho.com/.
   At the time of writing this blog, Pentaho 5.3 and we download it using this command
   
   wget http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.3/biserver-ce-5.3.0.0-213.zip
3. Unzip the folder 

Having ALL data with muli select

Solution:
http://forums.pentaho.com/showthread.php?193329-ALL-Condition-with-Multiselect-dropdown-replacing-ALL-in-query

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 : http://pedroalves-bi.blogspot.it/2013/10/sparkl-pentaho-application-builder.html
http://forums.pentaho.com/showthread.php?151358-Sparkl-A-Pentaho-Application-Builder

How to work with sparkl : http://fcorti.com/pentaho-sparkl/

Getting some useful tips to create your first production dashboard: http://diethardsteiner.github.io/review/2014/08/10/Pentaho-Sparkl-Tips.html

If you wish to check how to debug the kettle endpoints: http://forums.pentaho.com/showthread.php?156393-Debugging-Sparkl-applications-Pentaho-JCR-Repository-Synchronizer-real-world-example

Documentation to develop plugin: http://wiki.pentaho.com/display/ServerDoc2x/Developing+Plugins

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"
               connectionTimeout="20000"
               redirectPort="8443" />


3. Change this to :
<Connector URIEncoding="UTF-8" port="8080" protocol="HTTP/1.1"
                connectionTimeout="20000"
                compression="on"
                compressionMinSize="512"
                compressableMimeType="application/json,application/xml,image/gif,image/png,text/css,text/html,text/javascript,text/plain,text/xml"
               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 http://jira.pentaho.com/browse/BISERVER-10222

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:

Reference:
http://pentaho-bi-suite.blogspot.in/2014/04/hide-cda-and-tmpcda-files-in-pentaho-ce.html
http://forums.pentaho.com/showthread.php?153655-Pentaho-5-How-to-unhide-folder