0 
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 – 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
Related posts:
OOW 2012: Data Visualizations with ADF DVT – continuous evolution demonstrated 
ADF DVT: Sunburst to quickly inspect the hierarchical composition 
ADF DVT Hierarchy Viewer on demand – made to order multi table hierachy view 
ADF DVT Speed Date : Meeting The Hierarchy Viewer 
ADF DVT: Using the Tree Map visualization component – to compare relative sizes and distributions
