I’ve worked on several customer dashboards and found the charting in Pentaho to be pretty good in a lot of circumstances, but lacking for a lot of circumstances. In particular, certain shading, animations, etc aren’t supported in Pentaho charts (based on JFreeChart).
There are a bunch of Flash charting libraries, and I recently worked with a customer that was using “Open Flash Charts.” I helped them get Mondrian data streaming through to this flash charting engine. I was surprised to find that the library is open source, and is moving to LGPL (away from GPL) to ensure that people feel comfortable embedding it in their applications.
I started integrating these charting capabilities with Pentaho to see how the charts look. I was seeing some really great results. The integration was done via a fair amount of fancy Javascript/Xaction sequence stuff but this integration did not require any custom Java application work. Just Pentaho .xactions and the basic open-flash-chart.swf. I might start looking at building a small little JSP library to help with some of this.
The first one I built was a little pie chart, that has a nice animation (copied and pasted here without the dynamic .xaction stuff)
The second one I built was this beautiful bar chart, comparing actuals and budgets.
In all cases, if you’re needing some “more” from Pentaho in terms of data visualization, don’t hesitate to be in touch. This flash chart is the latest in a series of dashboards that Bayon has been building for customers.
UPDATE: I built another one for a new customer, and changed the data labels for presentation here. Having a grand time with open flash chart. This chart below is the output of an MDX query to Mondrian. The one is the metric ( a base measure ) the other is a running total.
Hey Nick!
Thomas (also know as bugg_tb) has just informed me in ##pentaho about you getting this working!. Congrats man! I tried to to the same thing about a couple of months ago but only got as far as generating the charts in the format of .jsps.
Two things i have to ask though…
1. How did you get around the Data part? Did you actually link to a datasource or use the datafile technique?
2. Why didn’t you show your readers the Sketch chart! 😉
All the best, Harris
hey guys,Want to draw some cool Flash Charts then chk this out visifire
Thanks for the link love 🙂
Version 2 or open flash chart uses JSON as the data format, this means the chart can talk to javascript real nice.
Hope that may make AJAX stuff easier too.
Cheers,
monk.e.boy
added a link, since I didn’t.
I’ll check out the new JSON
If you stumbled across these nice charts but are a php, or even better, CakePHP user, an implementation helper for the OFC-2 charts may be found here http://code.google.com/p/alkemann/
Hi,
We have created few flash charts so im trying to drill down from the chart to jpivot Analysis view .My problem is im unable to fetch and pass the parameter. Can you please give me suggestions or any sample on Drill down in flash charts.
Thanks & Regards
Usha
Hi,
how to integrate with pentaho.
Thanks
mohan
Does anybody know how to have the values always turned on of, let’s say, bars from a bar chart so that one doesn’t have to mouse over the bars?
Hai,
can u tell me how draw charts by pentaho dash boards,by getting the data from the database
I have integrated the Open Falsh chart fro pentaho 2.0 and it is working well. I had 1 question regarding the steps and max values that are mentioned in the .txt files. for example in the ofc_bar_chart_3D.txt it requires the values for
1000000
10000000
Is it possible not to mention these values as in my case the values can be dynamic , so i want the chart to relatively grow depending on the values it gets.
I have integrated the Open Falsh chart fro pentaho 2.0 and it is working well. I had 1 question regarding the steps and max values that are mentioned in the .txt files. for example in the ofc_bar_chart_3D.txt it requires the values for
y-steps
1000000
y-steps
y-max 10000000y-max
Is it possible not to mention these values as in my case the values can be dynamic , so i want the chart to relatively grow depending on the values it gets.
Hi,
its good work.. i am also trying to implement the code in the server 1.6. but not getting result. So can any body tell which version on wards the system support flash chart.
can anybody give berif explanation
Thanks
shiju
Hi Congrats, for your good work…
And i want to generate the dashboards, i am already implemented with old format charts, i want to upgrade it to Flash based charts. If any one likes, please helps me to achieve it. I have my own database, even my old application is running in Penatho 1.6 OGA….
Thanks in advance
Cheers,
ragu
Hi,
Is it possible to use OLAP Cube data to populate the chart, and can we able to rotate the chart. If yes please provide the demo and sample code.
Thanks
Hi,
Can any one say how to use timeseries collector for two columns on y axis using pentaho.
thank u so much for helping
Thanks
Ramesh
Hi all,
i download Nick’s piechart example and i’m able to chang the SQLQuery to load my data and start it. Now i want pass the query parameter on runtime by a filter. I try but the chart always load the default input param. I try with a filter panel the set session param, the same value i try to load in my query.
Can you hel me?
Thanks
Hello I need help, want to create graphs with Open Fash Chart for pentaho. That is the first thing that I must do.
I try to use gbk code in pentahoopenflash, it occurs messy code. Doesn’t it suppose?
Is it possible to do a chart like this
http://www.jfree.org/jfreechart/images/DialPlotDemo2a.png
using Pentaho BI Community eddition?
Also Is it possible do Gap Analysis using the community edition?
If yes? using which Community project?
Thanks
Please help me to integrate the Open Flash fro Pentaho. How would I do it if I need to use higher values like miliion or ten million? If my values are dynamic, is it possible not to mention these values?
Hi,
I’ve problem to display data with values less than 1 (all of them are from interval 0 – 1). The “0” on the Y scale jumps to the top of the chart and nothing except x and y axes is displayed.
Is it bug or I’m doing something wrong? (Using Pentaho 3.6.0 EE).
Regards,
Rado.
Hi,
is it possible to integrate XML/SWF charts into pentaho too?
http://www.maani.us
thanks
great job…. hey i would like to know to how to make these flash chart reactive to mouse clicks using metalayer concept(i.e having component definition in some separate javascript file)…
Regards,
Sunny
Hi,
I’m trying to add a link to each bar in a bar chart. Each link has unique id appended the end of the link to use it as a drill down chart. I can assign a link to ALL of them but not add a unique value. Can anyone help me out?
Thanks,
Billy