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)

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

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



Refernce: http://forums.pentaho.com/showthread.php?177028-Redirect-to-dashboard-after-login

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 

Pentaho: Moving from http to https

Reference : http://pentaho-bi-suite.blogspot.in/2015/05/self-signed-ssltls-configuration-how-to.html

Pentaho User Console: Change default port

Reference : https://help.pentaho.com/Documentation/5.3/0P0/000/050

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

Creating Pentaho report using Rest API

Reference: http://woodlouse.blogspot.fr/2013/02/how-to-create-pentaho-report-using-rest.html

Use of dynamic variables to form URL
http://www.nathanhoeft.com/2012/03/24/couchdb-and-pentaho-data-integration/

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

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