ADF 12c – The Hierarchical Mystery Tour – Treemap, Sunburst, Treetable, Hierarchy Viewer and Thematic Map

0

Hierarchical data is common phenomenon in the real world. Presenting such data to allow users to quickly grasp the composition of numbers, to compare quantities, to navigate through a data set and to have a pleasant experience with potentially dreary facts is quite valuable. ADF 12c (as well as previous releases) offer a wealth of components that help us present data in interesting, meaningful ways. For hierarchical data, components that come to mind include the Hierarchy Viewer, the Treemap and Sunburst components and if the data is of a geographical nature the Map components. Of course the tree and treetable and pivot table can be used to present such data as well.

This article demonstrates the use of a number of these components on population statistics for cities, countries, continents and regions. I hope you spot the hierarchical pattern in this list. This YouTube movie (4.20 minute, no sound) shows the components in actions. The resources section of this article makes the JDeveloper 12c (12.1.2) application available for download, with all the source code inside.

Resources

Download JDeveloper 12.1.2 application: HierarchicalMysteryTour.

Blog article: plotting custom locations on Thematic Map – http://technology.amis.nl/2011/06/08/adf11gr2-plotting-custom-locations-on-a-thematic-map-using-a-geocoder-service/

Find Longitude and Lattitude for any world location – http://www.worldatlas.com/aatlas/findlatlong.htm

list of the current officially assigned ISO 3166-1 alpha-3 code – http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3

Color code generator – http://www.2createawebsite.com/build/hex-colors.html#hextool

Share.

About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director for Fusion Middleware. Consultant, trainer and instructor on diverse areas including Oracle Database (SQL & PLSQL), Service Oriented Architecture, BPM, ADF, Java in various shapes and forms and many other things. Author of the Oracle Press book: Oracle SOA Suite 11g Handbook. Frequent presenter on conferences such as JavaOne, Oracle OpenWorld, ODTUG Kaleidoscope, Devoxx and OBUG. Presenter for Oracle University Celebrity specials.

Leave a Reply