How to create CDE Dash Board in Pentaho

1. Log into the Pentaho User Console, and launch the CDE

You can launch the editor from the PUC home page, from the PUC menu (File > New > CDE Dashboard), or by clicking on the CDE icon in the PUC toolbar.

2. Save the dashboard

Give the Dashboard a name and save it in the solution folder of your choice, and then close the Dashboard.

3. Edit the dashboard

Refresh the console by clicking F5 (or the keyboard shortcut Ctrl + R), find the Dashboard, right-click it and select Edit. The Dashboard editor will appear.

4. Design the Layout

Select the Layout perspective and define the dashboard layout according to your sketch.

5. Add the datasources

Select the Datasource perspective and define the datasources that will feed your Dashboard.

Create Parameter using Generic component.

use below Query to populate  continents from World Database (Mysql)

select Distinct Continent from world.country

select name,Population from world.country

where Continent = ${Conti}

limit 5

6. Add and configure the components

Select the Component perspective and add the components that make up your Dashboard: the visual elements, the parameters, and eventually some scripts.

7. Preview your work

Click on Preview regularly to see how your work is progressing. Repeat steps 5-8 until you are satisfied with your final dashboard. Don't forget to save your work from time to time.

Download Dash board Sample file of Above Example from Below link

https://drive.google.com/file/d/0B_j1hJxesvxddEkzbWowUnFYVm8/view?usp=sharing

Please use My SQL with World Databse
you can download world database free from Mysql web site.