Posts tagged pivot table
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:
A heat-map according to the definition found in Wikipedia is "a graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors." This representation is used to quickly interpret a potentially large number of values in what can be sizable grid of values. Heat-maps are used to find hot-spots and cool areas – to determine for example deviations from the average or threshold value.
This article shows how the PivotTable in the ADF 11g RichFaces Data Visualization Tags library can be used to create such a Heat Map. In just a small number of simple steps, this heat-map can be realized. We will see this in an example: a heat-map based on the grid of Job vs. Department with average Salary in the cells. The heat-map should quickly tell us which jobs and which departments pay well or lousy.
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.