Tuesday 27 April 2010 - Pivot Table

Have you ever wanted to display a pivot table in your application, but could not, due to the complexities involved?
Well now you can, with our pivot table java component.

Our pivot table framework is an extension of our Table Library product, which has been in the market for the last five years, and used by numerous customers in various applications. Table Library itself is an extension of Java's Swing and in particular of the JTable framework, which makes it easy to understand and program. In addition, it presents developers with a great deal of customization.

With our pivot table, you can produce powerful reports, with data residing in any OLAP database, such as Oracle or MS SQL Server. Just as easy, multi-dimensional reports can be created from data originating from flat files or relational SQL databases.

All OLAP functions are supported and implemented, such as pivot, slice/dice, roll-up/drill-down, paging etc.

Great care has been given to the pivot table API. Following a minimalistic approach, the API is as easy to understand as it is flexible and robust. The library is highly optimized for low memory consumption and speed.

Last but not least, by making use of J2EE technologies, the underlying multi-dimensional data may reside on the server side, and numerous clients can be deployed anywhere, inside or outside your corporate network.

In short, the main features are:

• create multi-dimensional pivot tables using 100% Java's Swing.

• connect to any OLAP-enabled database, such as Oracle or MS SQL server, using the industy standard XML/A language, or other vendor-specific drivers

• create pivot tables from any relational SQL database, or from flat files (csv, txt etc)

• hierarchical display

• any number of dimensions can be pivoted, either to the ROW or COLUMN edges of the table

• measures can also be pivoted, which means that you can display more than one measure in the table

• sorting and filtering support on the members of each dimension, by selecting distinct members or by using OLAP functions such as TOP, BOTTOM etc.

• paging support and data filtering

• display summaries, grand totals and sub-totals

• context sensitive menus for dynamically changing the appearance of the pivot table

• ALL OLAP functions are implemented, such as splice/dice, roll-up/drill-down

• pivot dimensions can be dynamically changed by the use of drag and drop

• beautify and improve appearance of pivot table by using different colors, fonts etc on each cell

• distributed environment: data may reside on server side and be deployed to numerous clients

• asynchronous calls: pivot table does not freeze while fetching data from the OLAP cube

• great API: easy to use and understand, yet highly flexible, customizable and robust

• rapid application development (RAD): our pivot table extends Swing and in particular JTable, therefore very few new classes are introduced, which makes the API easy to learn

• small library size: depending on the features used, the library can be compacted to as low as 500 kb.

• highly optimized for low memory consumption and performance

• great same business day support via forum or e-mail

• source code available

Please contact us at info@scientific.gr for more information.

Video Tutorial

We have created a video tutorial that shows how end-users can interact with the pivot table.
Please click here to download it.

Online Demos

We have two demos online. You will need to have java webstart installed on your computer in order to run them.

1. Pivot table demo with data originating from SQL relational database

The data, which has been drawn from the northwind database, is shown on the table at the bottom.
Users are able to pivot predefined dimensions in the row or column axis of the table, or place them in the paging space.
Measures can also be pivoted. Just drag a dimension from the list on the right and drop it on the table's header, or drag a dimension from the header itself.
It is also possible to select paging parameters by clicking on the (...) button of the paging list.

Click here for the demo

2.  Pivot table demo with data from Oracle database

This demo shows a pivot table with data from the sample Oracle database, GLOBAL.
Data reside on our own server and are retrieved by the client asynchronously. While data are being retrieved,
an indicator at the bottom of the application is shown, and the cells that contain not-yet-fetched values appear in yellow.
Once values are retrieved, they are cached by the client, so they do not need to be retrieved again.
NOTE: If you are behind a proxy server, make sure that you enter your proxy server’s credentials, by clicking on the ‘settings...’ button.

Click here for the demo