Posts tagged dvt
Using ADF 11gR2 DVT component Pivot Table for an on-line analysis of the ODTUG Kaleidoscope session catalog0
ADF comes with a rich collection of component that allow us to visualize and analyze data in ways that previously were only available in fancy OLAP and other BI tools. Now, our own custom developed ADF applications can offer those same fancy capabilities using ADF DVT. Note that Oracle’s BI tools – such as OBI EE – make use of those same components.
This article demonstrates the use of the Pivot Table component – as it is currently shipped in ADF 11gR2. This component presents data in initially very condensed, highly aggregated form and allows the user to ‘slice and dice’ and drill down and aggregate along various dimensions.
The Pivot Table is used in this case to analyze the data for the sessions scheduled for the ODTUG Kaleidoscope 2011 conference, later this month, in Long Beach, California. The article will demonstrate that just a few, declarative steps and about 10 minutes of your time are quite enough to include rich analytical capabilities in an ADF application.
The initial Pivot Table shown to the user looks as follows:
One of the data visualization tags required by the teams working on the Oracle Fusion Application Module for Human Resource Management, was a component capable of rendering organization charts. Hierarchical structures from CEO all the way down to the youngest trainee. In a pleasing, graphically interesting, somewhat animated fashion. And so the ADF team developed the Hierarchy Viewer. And since they developed it anyway, we can now make use of it as well. While it may not be the component you will most frequently use, it is certainly an interesting presentation option for special data structures. This component can work against the same tree data binding you would use for tree tables or trees, and can therefore be configured in a very simple, declarative fashion.
In this article some simple examples of how to use this new component. This article is the short summary of a presentation and demonstration I did at the recent ODTUG Kaleidoscope 2009 conference (late June, Monterey). It demonstrates how the conference’s session schedule can be represented in the Hierarchy Viewer.
One of the sweet spots in ADF 11g RichFaces is of course the library of Data Visualization components. I have written about PivotTable and GanttChart in the past and would now like to also say a few words about Gauges. The collection of Gauges in ADF 11g is quite useful. We will see how easy it is to leverage a Gauge to provide more insight in data.
One of the very interesting JSF components that ADF 11g RichFaces has put in our hands is the Pivot Table. I have blogged about that component a while back (see ADF Faces 11g: Reloading the Matrix – using the Pivot Table component) – and now it is time to take the next step with this component. I have been getting some assistance from the ADF DVT team – Katia’s gang – and with their help I am able to demonstrate some ‘second step’ functionality for the pivot table – things that you do not do in the Pivot Table 101, that I described in the previous article.
First we create the Pivot Table – Timesheet – based on a Placeholder Data Control (with static sample data). We will run the page that contains the Pivot Table and see how versatile this already is. We will create a context sensitive context menu that displays additional information about the cell for which it was opened. We will also see how we can add data specific formatting to the cells.