Post navigation

Complete Pentaho Installation on Ubuntu, Part 11: C*Tools Dashboards

[Note: Install instructions posted on 2011 are no longer maintained by the developers. Please use the option ‘The Marketplace’ on the Pentaho User Console. The Dashboard building guide and reference links still works].

Install the Dashboard Editor

Webdetails is the contributor of C*Tools to the Pentaho Suite and is made of:

CDF: Community Dashboard Framework
This HTML/javascript framework is part of the BI Server distribution. It let’s you create pages with reports, charts and tables.

CDA: Community Dashboard Access
These are several components that give access to diferent types of datasources.
However there is a security warning about the posibility of sql injection, so if you are not on a secure environment think twice about instaling this.

CDE: Community Dashboard Editor
This is the web interface that lets you build a HTML/CSS layout and connect it to page elements, datasources and events so you can build your interactive Dashboards.

Make a backup of your Pentaho folder
at least a copy of Pentaho/biserver-ce/pentaho-solutions/

Delete the following folders (some of them will not exist on first install):/biserver-ce/pentaho-solutions/system/pentaho-cdf/biserver-ce/pentaho-solutions/system/pentaho-cdf-dd/biserver-ce/pentaho-solutions/system/cda
/biserver-ce/pentaho-solutions/cdf/biserver-ce/pentaho-solutions/cde_sample/biserver-ce/pentaho-solutions/bi-developers/cda

If you like things the easy way, you can download a small shell script and run it from a terminal. It will check for the latest release, do all the upgrades and even install Saiku.

These are notes from Pedro Alves page on github, his blog post or get the shell script here.

Using the CDE

To start the CDE you can click on the toolbar or use Edit->New

CDE New Dashboard

You have three areas:

Layout:
You click on the row (=) icon to create a row, and click on the parallel lines (||) to insert a column, and then you can click on the (<>) icon to insert HTML text. To do that you have the properties and events on the right column. Note: If you give elements a name you can use it as an ID on your CSS/javascript code.

Components:
You can define parameters as your variables.
You can specify in components (selects, charts, html tables, etc.) the parameter to hold values, or associate them with datasources to get data at startup, or tell them to which elements they need to listen for changes, which component ID will they get displayed on or what code to use on some events.

Datasource:
You can define all kind of queries to your data, depending on your datasource.

CDE Areas

Additional tips:

There is no global error checking and with so many setting options it is better to ‘preview’ your changes often.

To test the datasource (CDA) part of your dashboard you can select the .cda file on the left bottom panel and right click to open it. Your parameters will be used to run a test to your data.

Save often also. If you don’t like your changes not all optios have undo capabilities.

To edit a dashboard use: Edit (you need to have the sources)

CDE Edit

The componets have a link for advanced settings

CDE JS Functions

You can use javascript on clicks, pre or postprocessing, just name the functions:
function f(){ param2=param1-1; }

Demos:
– Five webdetails dashboards at pedroalves-bi.blogspot.com that can inspire you.
– Stratebi has a demo also at sample.stratebi.es, register for free access.
– Ambient shows its tips and work on a CDE implementation of a Steven Few sample of a CIO Dashboard.

[In Spanish] Dashboard creation: http://churriwifi.wordpress.com.
And another post on how to use xaction, CDE, MDX and charts working in a dashboard, with code and videos, from startebi in dataprix.I suggest you use google translation as they are good articles and you can skip to the code.

Acknowledgement

Thanks to Catarina Félix this post was written, her email with the documentation draft and installer script made me curious and started me in the right direction to overcome the initial fear of the neon-nightclub-CDE interface. 🙂

Thank you so much for your awesome tutorial !
I just have a little trouble. I followed you tutorial to install pentaho and migrate to mysql. I’m using CDE to create my dashboard. When I want to create a sql query with sql over sqlJndi, I can only use SampleData (which just works fine). I can’t use my datamart. Do you have an idea to add my datamart as a Jndi datasource ?
Thank you so much for you help !

Oh well you’ll be cleaning resetting all the individual tools (PDI) and the ones in the BI Server (CDA, Mondrian, Web Browser, users) often to reload metadata.
Thanks for your time in compleating this notes.

Hi errachdy,
I have added sidenotes on every post on major differences for windows installs. But if you need detailed steps even with different databases, try http://www.prashantraju.com/projects/pentaho/ its a great resource.
If you have specific questions please write them down here Im shure they will be interesting for all.

Hi!
I follow your guide, I still face this problem: when I launch or preview a CDE dashboard:
HTTP Status 500 – Could not initialize class com.orientechnologies.orient.core.version.OVersionFactory
type Status report

message Could not initialize class com.orientechnologies.orient.core.version.OVersionFactory

description The server encountered an internal error (Could not initialize class com.orientechnologies.orient.core.version.OVersionFactory) that prevented it from fulfilling this request.
Apache Tomcat/6.0.29

Never seen that error about ‘orientechnologies’.
My guess is that some component is not properly isntalled.
Try uninstalling CDE, CDA, CDF using the marketplace, then reboot or reestart the server and install them again (trunk, not latest) and reboot/restart once again and lets see.