Create CDE Dashboard with CCC Charts in Pentaho

This blog explains the process of creating a CDE dashboard in pentaho using CCC charts component.

Prerequisites:

1. Foodmart database
2. Pentaho 6.0.1.0.386

Below is the dashboard to be created in pentaho using CDE.



Procedure to be followed:

1. Click on Create New –> CDE Dashboard



2. CDE dashboard panel is as shown



3. There are 3 panels in CDE dashboard which are present in the right corner of CDE dashboard panel.
1. Layout Panel



It is used to create layout of the dashboard where we specify the number of columns, rows and placement of them.

2. Component Panel



It is used to add components required like tables, text boxes, charts etc.

3. Datasources Panel



It is used to add data source required.

4. Creation of layout is the first step.Based on the requirement, create a layout i.e. we need 2 rows and 2 columns in the first row.


Mandatory properties of row to be filled


Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Get your 30 Days Trail Version

1. Name: name of the row which acts as HTML id too.
2. Height: height of the row

Mandatory properties of a column to be filled:

1. Name: name of the column which acts as HTML id too
2. Height: height of the column
3. Extra Small,Small,Medium and Large devices: bootstrap parts which makes the configuration of the columns simple.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

The columns in a row must occupy 12 spans, such that in a single row you could have the following sample configurations:

1. Twelve columns of size 1 (12×1)
2. Two columns of size 6 (2×6)
3. Three columns of size 4 (3×4)
4. One column of size 8 and one column of size 4 (8+4)

Properties of column used is as shown



5. Next, we need to add 3 data sources (sql over sqljdbc) with 3 queries each for each chart.
6. For bar chart, we need state wise sales data.

Query for bar chart:

select s.store_state,sum(f.store_sales) sales
from sales_fact_1997 f
left join store s
on f.store_id=s.store_id
where s.store_country='USA'
group by s.store_state

7. The properties to be given in data source are as shown



Driver : org.postgresql.Driver
Password : postgres
User name : postgres
Access Level : public
URL : jdbc:postgresql://localhost:5433/foodmart

8. Similarly, add data sources for pie chart and bar chart.

Query for Pie chart:

select s.store_state as State,count(store_name) as Stores
from sales_fact_1997 f
left join store s
on f.store_id=s.store_id
where s.store_country='USA'
group by s.store_state

Query for Line chart:

Select a.Month,a.Sales
from
(select t.the_month as Month,t.month_of_year,sum(f.store_sales) as Sales
from sales_fact_1997 f
left join time_by_day t
on f.time_id=t.time_id
where t.the_year=2012
group by t.the_month,t.month_of_year
order by t.month_of_year) as a 

9. Add required chart components in component panel under charts section i.e. CCC Bar Chart, CCC Pie Chart and CCC Line Chart.

Mandatory properties of a chart components to be filled:

1. Name: name of the chart component
2. Title: title of the chart component
3. Height: height of the chart component which should be less than the height of the column component into which chart is placed.
4. HTML Object: name of the column/row in the layout section depending on the location of the chart component
5. Datasource: Specify the datasource created.







10. Save the dashboard and preview.



In case if you have any queries please get us at support@helicaltech.com

Thanks,
Mounika Pulimamidi
BI Developer
Helical IT Solutions Pvt Ltd


Best Open Source Business Intelligence Software Helical Insight is Here


A Business Intelligence Framework


Free
Download
CDE Dashboard Overview Pentaho Documentation Create CDE Dashboard with CCC Charts in Pentaho Dashboard creation with Pentaho and CDE pentaho pentaho cde dashboard parameters pentaho community edition 9.0 download pentaho consulting pentaho consulting services pentaho report designer 9.2 download The Good way to create pentaho cde dashboard