Inter panel communication in pentaho CDE

In this post you will learn how to communicate with the other panels in the same dashboard.

Example Scenario :
Panel 1 : BarChart is placed in panel-1
Panel 2: Table data displayed in panel-2

Functionality : The ideal functionality expected is when we click on any of the bars (panel 1), then the panel 2 should get updated and corresponding data should be displayed in 2nd panel. i.e., Make use of parameters, clickAction property, Listeners.

Example Developed on :
Pentaho 5.0 CE server
Pentaho C-Tools version : 13.09
Database : postgresql-foodmart( jasper food mart database)

Steps:
1) Create parameter (Lets say : param1_position_title)
2) Add it to listeners & parameters in your table component.
3) Add it to parameters in your data source for table query
Example:
SELECT
employee_id,
full_name,
position_id,
department_id
FROM
employee
WHERE
position_title=${param1_position_title}

4) Add to parameters in your chart(bar chart).

5)  BarChart query example:

SELECT DISTINCT
position_title AS position,
sum(salary) AS salary
FROM employee
GROUP BY position_title

6) In the chart properties
clickable = True
clickAction
function fun()
{
Dashboards.fireChange(‘param1_position_title’, this.scene.atoms.category.value);
}

Get in touch with us for any Pentaho related consultation, query

1 comment

  1. Leidiane

    Having in depth experience with both, I’d have to agree with InfoWorld’s reievw. Jasper is handy for departmental reporting, but pales in comparison to Pentaho for large scale, enterprise wide deployments. Also, if you are considering expanding your BI solution beyond reporting, Jasper is a bit of a dead end.

Leave a Reply