X

An Oracle blog about BI Publisher

Tree Maps

More mails this week, its funny how you get a batch of requests for something all at the same time. This past week the proverbial hot potato has been Tree Maps and how to make em?

For the uninitiated, a tree map is a 2 dimensional graphical visualization of your data e.g. school size + absenteeism, maybe your debtors and the size of their debt and their delinquency or your organizations current project load, their relative size and how far behind or ahead they are compared to plan. For a large amount of data, say, listing on the stock market its very hard to compared whos up and whos down just by looking at tabular data. You can color code the data for sure but if you have masses of rows its tough to compare. A tree map gives you a easy visualization of common entries and they are color coded to make life even easier.

TreeMap1.jpg

In the graphic above we can see schools in a school district, the size of the of the rectangle is affected by the school student population ie a bigger one for a larger school. The color of the rectangle is governed by the difference from an attendance target the school has for a given day.

Now you know what they are, so how do you build em?

I first looked at RTF templates, they can do so much and they can partially help but only for single dimension data. We can conditionally color a table cell based on some data but resizing that cell gets very complicated very quickly - I ended up in hard core XSL too quickly. I did find a brave soul out on the intertubes that had built several XSL style sheets to get the tree map - IMHO its just too expensive a development. If you only need a sing dimension then RTF templates are quick and easy.

TreeMap2.jpg

You can get the template and data here.

Much more useful and altogether more cool from an output format standpoint is the good ol Flex template. I have not looked at Flex for a while, digging back into it I was amazed at the amount of open source development going on around building re-usable flex components. Don't want to build it yourself, go google for it. The Google Code site has masses of components and examples, just search for it. That's just what I did and came up with Josh's tree map component page. Its covered by an Open Source license from MIT so both kudos and thanks to Josh for it.

Seeing the MIT license got me digging through links to see what else might be out there from the MIT brainiacs. All you could ever want to know about tree maps.

Then I found this site, the MIT Simile Widgets - some awesome stuff going on in there, not Flex necessarily but some very rich interactive visualizations.

Getting back to Tree Maps and Flex - using the component in a project is easy enough, getting Publisher to generate data that will work with the component is a whole other kettle of fish ... I'll save that for tomorrow ...

Join the discussion

Comments ( 4 )
  • Espen Hartwich Sunday, October 26, 2008
    Cool, a cliffhanger :) I thought I was at the main blog page - clicked via Twitter -
    so I thought I'd have to wait for the follow-up. But I can see it's here already :)
    So I just wanted to say: Interesting subject (tree maps with BIP). Now to read on..
  • cebu city street map Thursday, January 29, 2009
    This is great information, I need to start a blog on my site and hopefully it will really help me get some better traffic!
  • imileMype Thursday, February 5, 2009
    Im on a mission, trying to gather information on some H.I.D bulbs for my 1997 Audi and was wondering if anyone had any tips?
    We have located these blogs for information but any personal experienced tips would be really helpful.
    Hid Kit
  • CD Rate Sunday, December 20, 2009
    Wow, just found my new favorite blog right here. Really well written post, bookmarked you for future reference.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.