{"id":259,"date":"2008-06-11T14:50:58","date_gmt":"2008-06-11T21:50:58","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2008\/06\/11\/beautiful-flash-charts-for-pentaho\/"},"modified":"2008-06-11T14:50:58","modified_gmt":"2008-06-11T21:50:58","slug":"beautiful-flash-charts-for-pentaho","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2008\/06\/11\/beautiful-flash-charts-for-pentaho\/","title":{"rendered":"Beautiful Flash Charts for Pentaho"},"content":{"rendered":"<p>I&#8217;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&#8217;t supported in Pentaho charts (based on JFreeChart).<\/p>\n<p>There are a bunch of Flash charting libraries, and I recently worked with a customer that was using &#8220;<a href=\"http:\/\/teethgrinder.co.uk\/open-flash-chart\/\">Open Flash Charts.<\/a>&#8221;  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.<\/p>\n<p>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.<\/p>\n<p>The first one I built was a little pie chart, that has a nice animation (copied and pasted here without the dynamic .xaction stuff)<\/p>\n<p style=\"text-align:center;\"><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http:\/\/fpdownload.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=8,0,0,0\" width=\"300\" height=\"300\" id=\"graph-2\" align=\"middle\"><param name=\"allowScriptAccess\" value=\"sameDomain\" \/><param name=\"movie\" value=\"\/entry_images\/open-flash-chart.swf?width=500&#038;height=250&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fpie_data.txt\" \/><param name=\"quality\" value=\"high\" \/><param name=\"bgcolor\" value=\"#FFFFFF\" \/><embed src=\"\/entry_images\/open-flash-chart.swf?width=300&#038;height=300&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fpie_data.txt\" quality=\"high\" bgcolor=\"#FFFFFF\" width=\"300\" height=\"300\" name=\"open-flash-chart\" align=\"middle\" allowScriptAccess=\"sameDomain\" type=\"application\/x-shockwave-flash\" pluginspage=\"http:\/\/www.macromedia.com\/go\/getflashplayer\" \/><\/object><\/p>\n<p>The second one I built was this beautiful bar chart, comparing actuals and budgets.<\/p>\n<p style=\"text-align:center;\"><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http:\/\/fpdownload.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=8,0,0,0\" width=\"400\" height=\"300\" id=\"graph-2\" align=\"middle\"><param name=\"allowScriptAccess\" value=\"sameDomain\" \/><param name=\"movie\" value=\"\/entry_images\/open-flash-chart.swf?width=400&#038;height=300&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fbar_data.txt\" \/><param name=\"quality\" value=\"high\" \/><param name=\"bgcolor\" value=\"#FFFFFF\" \/><embed src=\"\/entry_images\/open-flash-chart.swf?width=400&#038;height=300&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fbar_data.txt\" quality=\"high\" bgcolor=\"#FFFFFF\" width=\"400\" height=\"300\" name=\"open-flash-chart\" align=\"middle\" allowScriptAccess=\"sameDomain\" type=\"application\/x-shockwave-flash\" pluginspage=\"http:\/\/www.macromedia.com\/go\/getflashplayer\" \/><\/object><\/p>\n<p>In all cases, if you&#8217;re needing some &#8220;more&#8221; from Pentaho in terms of data visualization, don&#8217;t hesitate to be in touch.  This flash chart is the latest in a series of dashboards that Bayon has been building for customers.<\/p>\n<p>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.<br \/>\n<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http:\/\/fpdownload.macromedia.com\/pub\/shockwave\/cabs\/flash\/swflash.cab#version=8,0,0,0\" width=\"500\" height=\"300\" id=\"graph-2\" align=\"middle\"><param name=\"allowScriptAccess\" value=\"sameDomain\" \/><param name=\"movie\" value=\"\/entry_images\/open-flash-chart.swf?width=500&#038;height=300&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fcombo_data.txt\" \/><param name=\"quality\" value=\"high\" \/><param name=\"bgcolor\" value=\"#FFFFFF\" \/><embed src=\"\/entry_images\/open-flash-chart.swf?width=500&#038;height=300&#038;data=http%3a%2f%2fwww.nicholasgoodman.com%2fentry_images%2fcombo_data.txt\" quality=\"high\" bgcolor=\"#FFFFFF\" width=\"500\" height=\"300\" name=\"open-flash-chart\" align=\"middle\" allowScriptAccess=\"sameDomain\" type=\"application\/x-shockwave-flash\" pluginspage=\"http:\/\/www.macromedia.com\/go\/getflashplayer\" \/><\/object><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;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&#8217;t supported in Pentaho charts (based on JFreeChart). There are a bunch of Flash charting libraries, and I recently worked with [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/259"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}