Posts tagged dvt
Recently the ADF Special Interest Group at AMIS organized an ADF DVT Speed Date. During this speed date, six ADF specialists from our team presented their favorite Data Visualization Component from the DVT library. In a series of blog posts we share the information with a broader audience. In this post you get introduced to Gantt Charts – which was my own date for this party.ADF DVT Gantt Chart – Introduction
The probably most distinguishing feature of any Gantt Chart is the horizontal time axis. Gantt Charts are used to present data against time.
Gantt Charts were invented in the 1910s by Henry Gantt (hence the name) – although a Polish engineer probably beat him to it but forgot to blog about it (http://en.wikipedia.org/wiki/Gantt_chart). They were used initially for presenting Project Schedules – showing tasks with their start time and end time and their dependencies. The essence of many modern project management tools is in fact a Gantt Chart – frequently an interactive one.
ADF DVT provides this project- and task overview in a Gantt format. Two additional Gantt Charts are provided as well:
In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions in SQL to cleverly (!) derive the valid periods from a database table that contains periods of inclusion and exclusion. A valid period is a period for which there is at least one inclusion and for which there is no exclusion. I used several powerpoint based graphics to illustrate the business case. For example:
to depict the periods of inclusion and exclusion and this figure to demonstrate how to derive the valid periods (the blue bars):
After completing this article – and fiddling around in Powerpoint quite a bit – I realized that for visualizing data in a table, I have a perfect tool at my fingertips: the Data Visualization Tags (DVT) in ADF 11g are created for this very purpose: turning data into information through visualization. And this rich library of DVTs components contains – in addition to fairly straightforward visualizations such as bar charts, pie charts and line graphs – also more complex visualization components such as the Bubble Chart, Thematic Map and Gantt Chart. The Gantt Chart has three More >
Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om te experimenteren én te leren samen met de experts op je vakgebied.
Laat ons in een vrijblijvend gesprek vertellen welke mogelijkheden we je kunnen bieden. Neem voor een afspraak met een van onze consultants contact op met Eva.email@example.com of bel haar op 030-6016000. Je bent van harte welkom.
AMIS merkt dat haar concept van hoogwaardige en kennisintensieve dienstverlening erg succesvol is. Onze toekomst ziet er erg aantrekkelijk uit met interessante opdrachten bij toonaangevende klanten. Vandaar dat we op zoek zijn naar uitbreiding van ons team.
Denk niet direct dat je hiervoor te weinig kennis of ervaring hebt: jouw toekomstige ervaren collega’s doen niets liever dan jou verder helpen. Ons trainingsprogramma voorziet in een grote diversiteit aan opleidingen en tijdens onze interne kennissessies kun je op veel terreinen iets van je collega’s opsteken. Concreet hebben we de volgende vacatures:
One of my favorite areas of ADF is Data Visualization. The rich, interactive and (un)usually attractive components that allow me to spice up an ADF application in a very easy straightforward way have a special appeal. We all know that pictures speak volumes. And that a plain table presents data while a carefully designed visualization presents information and perhaps even a call to action. One of my highlights during Oracle Open World 2012 was – not surprisingly – the presentation by the ADF DVT team – Katrina, Hugh and Jairam – together with Yiannis and Vangelis from PCS in Greece who built a wonderful ADF application for private investment management, with beautiful and very effective data visualizations all over the place.
The story of ADF DVT is one that started probably even before ADF with the BI Beans and before that perhaps even with Oracle Graphics. However, forget about all that history and look to the present and the future. No presentation of Fusion Applications is held without showing off its many data visualizations as a means to turn data into information and information into action. Drawing the user to exceptions, deadlines, alerts, patterns and items to act on is More >
This morning, I noticed the following email sitting in my Inbox: “Hello, Lucas.
I found Hierarchy Viewer demo from http://technology.amis.nl/blog/5786/adf-11gr1-new-hierarchical-viewer-for-visually-pleasing-representation-of-data-structures.
But i need to implement some kind of solution. I attached my expected mockup and table structure.
Is it possible? If possible, please suggest me how to do that and put your solution based on your experience.
I’m looking forward to hearing from you soon.”
Obviously, I normall completely ignore such emails – I do have a job you know, and some semblance of a normal life too. However, this email triggered me in some way. And between other more important things, I tried to create the desired hierarchy. The mock up looks like this:
The most challenging part is probably to get the query right. Once that query is defined – in a ViewObject with a selfrefencing ViewLink – creating the hierarchy is very straightforward. Some final styling is required – and a different design to the Radio Buttons, because those are not supported in the Hierarchy Viewer – but otherwise I think I did the job. My end result looks like this (from far away):
Note that the More >