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

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 – https://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