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)

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

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 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

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 : 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

Thursday, July 2, 2015

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/

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"
               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


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:


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

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