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

Pentaho Community Dashboard(CDE) basics - part2.. Extending the dashboard working with parameters

Hi.
This post is the extension of the below post

http://pentaho-bi-suite.blogspot.in/2013/07/pentaho-community-dashboardcde-basics.html

To start with this & if you are begineer in CDE you must go through the above link.

Agenda :
How to create a single select parameter ?
How to make the dashboard better look & Feel ?

Step 1: Layout section

* As shown in figure create a new column in first row
* Properties :
    Name: year_select
    Font : 17


Step 2: In DataSources Section

Name : get_all_years
Jndi: SampleData
Query :
SELECT DISTINCT YEAR_ID as YEAR FROM ORDERFACT ORDER BY YEAR_ID

Step3 : In Components Section
Name : year_picker
Parameter: year
Datasource : get_all_year
HtmlObject :  year_select