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/