Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Wednesday 24 August 2016

Tip : Sparkline in Pentaho CDE


1) Data Format for Spark line (field can be a string but it should be comma separated)


2) Data source connection in CDE and query

3) Define the column type in table component

4) Sample output



Sunday 21 August 2016

Pentaho Ctools CCC(Community Chart Components) charts latest demos dashboard-1 , dashboard-2 & dashboard-3

Hi,

Downlad and explore my latest demo workouts on CCC charts. In Ctools(CDE) there are majorly 18+ visualizations are available out of the box.

The 1st demo has...
1) Area chart
2) Bar chart
3) Box-Plot
4) Bullet chart-1 and Bullet chart-2
5) Dot chart and
6) Heat grid chart

(click on image to get best view)
2nd demo has...
1) Line chart
2) Metric dot chart
3) Metic line chart
4) 100% stacked bar chart
5) Dual level pie chart and
6) Stacked area chart

(click on image to get best view) 

3rd demo has...
1)  Stacked dot chart
2) Stacked line chart
3) Sunbrust chart
4) Treemap chart
5) Waterfall chart
6) Dial chart

(click on image to get best view)


This demo also have basic bootstrap CSS to make the panels zero border and change the colors of the panels. (have a close look at panels - showding effects are applied which makes good look and feel).

Note that the CCC components are not adjusted/added code to fit screen for mobile/tablet devices. Currently these supports desktop view.


Source code download and deployment procedure
1) Make sure you have"foodmart"database and "pentaho_cde_demo" databases are running on postgresql server with postgres/postgres as credentials. ( these two dbs are avaialble in download section as .backup files, restore them in your postgresql).
2) Upload the Dashboards2.zip file from PUC and check for the outputs.

Download

drop a comment if you have any problem in downloading or deploying the package.



Tip : How to create postgresql JNDI connection in Pentaho Data Integration (PDI) or Kettle ETL

Hi,

In this post you will see how to connect to postgresql "foodmart"database in PDI using JNDI concepts.

Software used : PDI 6.1 CE, PostgreSQL foodmart db

Steps :
1) Install postgresql driver in "lib"folder of PDI installation  (download driver here)
  Example : D:\data-integration\lib

2) Navigate to "sample-jndi" folder at PDI instllation  and open jdbc.properties file using notepad
3) Add below set of properties with foodmart database information

FoodMart/type=javax.sql.DataSource
FoodMart/driver=org.postgresql.Driver
FoodMart/url=jdbc:postgresql://localhost:5432/foodmart
FoodMart/user=postgres
FoodMart/password=postgres

NOTE : FoodMart is the JNDI name we use in PDI tool to connect foodmart database

4) Launch the PDI tool and create a  new transformation
Click on View tab -> then under the transformation name right click on "Database connectioin"node to create a new connection
Give a name for the connection and in the setting write "FoodMart" as the JNDI name
make sure that you are accessing "JNDI" from General selection.


 5) Click on "Test" button to see the successfull connection of JNDI. note that you need not to relaunch the PDI tool if you are modifying only properties file with foodmart information. Incase of installating driver if your PDI is running, a restart/relaunch of PDI tool is required.


Cheers.!
Sadakar Pochampalli 










Wednesday 10 August 2016

Example : Customer Vehicle Summary sample dashboard in Pentaho CDE

Hi,

This example has below features

1) Dynamic features with parameters
2) Drill down functionality on first dashboard
3) Extension points
4) Query component example
5) Rectangular Boot strap panels
6) Online image URL
7) Interactivity features of pie charts
8) Table component in drill down dashboard
9) Drill back to Home dashboard from detailed dashboard
10) Basic CSS, CDF based java script functions.

(Click on image to get best view of the dashboard)

Summary Dashboard : 
Drill down dashboard:

NOTE : note that this dashboard is not made for mobile devices though uses bootstrap panels.


Download Example Here: Click me

Deployment process is : 
1) Upload the zip file to your pentaho 6.1 CE/EE
2) Make sure you run postgresql server having foodmart database of Jasper Server

Thank you
Cheers.!
Sadakar Pochampalli