A pivot table is an element for reviewing, managing and evaluating millions of information. It's the most significant visualization interface of the OLAP (OnLine Analytical Processing) system. With this program, you may create state-of-the-art pivot tables in Java/Swing plus incorporate all of them with your present Java software.

Citra Pivot, an expansion to the Citra Table factor, is a platform coded in Java/Swing for developing and picturing pivot tables. Pivot tables can be developed from OLAP Servers contouring towards the XML/A standards, but furthermore from in-memory two-dimensional details, via flat documents.

Features incorporate normal OLAP functions, for example filtering, sorting, drill up/down/through, slice and dice, empty cell hiding, visual totals, grand totals, subtotals, top/bottom operations, axis swapping. A variety of hierarchies could be pivoted, either visually or programmatically, by drag n' drop. The table's visual appeal can be simply personalized by utilizing various hues plus fonts for every cell. Context sensitive popup options give a intuitive experience.

The library can be optimized for minimal memory usage and higher efficiency. The API is straightforward, yet effective, and simple to understand. Finally, since Citra Pivot is dependent on Java/Swing, it may be conveniently built-into latest Swing programs and apps.

In a nutshell, the primary Features are:
-Platform independent: it generates multi-dimensional pivot tables inside the Java/Swing structures.
-Raw Data: together with OLAP databases, data could also derive from two-dimensional files or structures, developed from relational SQL databases or else.
-Connectivity: link with any OLAP Server, for example MS SQL server or Mondrian, Oracle, which contours towards the industry standard XML/A specs.
-Input independent: whether sources are flat files or an OLAP database, user code for developing and adjusting pivot tables continues to be identical.
-Multiple pivoting: a variety of hierarchies could be pivoted, either to the ROW or COLUMN regions of the table.
-Hierarchical display: the tree-like components with extensible nodes.
-Measure pivoting: it measures may also be pivot, which indicate that you can show several measures within the table.
-Filtering: it removes (hide) certain members of a hierarchy.
-Sorting: descending or ascending sorting based on the people in each hierarchy (alphanumerical), or even the measure values they symbolize.
-Slicing: it generates data slices, by putting a hierarchy within the FILTER region.
-Grand Totals: hide/show row and column grand totals.
-Efficiency: every OLAP features are supported, for example pivot, empty cells, roll-up/drill-down, slice/dice, filtering, sorting, top/bottom, visual totals.
-Subtotals: hide/show particular member subtotals.
-User friendliness: the context sensitive options for dynamically transforming the look of the pivot table as well as for implementing OLAP functions, for example axes, top, bottom swapping and much more.
-Drag n' drop: the hierarchies could be pivoted powerfully by means of drag n' drop.
-Asynchronous calls: the pivot table doesn't freeze whilst getting information from the OLAP cube.
-Appearance: accentuate and modify the visual appeal of the pivot table by utilizing various shades, fonts etc for every member and data cell.
-API: simple to use and figure out, yet highly versatile, personalized and robust.
-Rapid Application Development (RAD): expands Swing especially JTable, consequently not many new classes are released, making the API simple to understand.
-Optimization: well optimized for performance and low memory consumption, by limiting the amount of queries towards the database.
-Support: same working day support through e-mail or forum.
-Small size: relating to the features utilized, the library could be compressed to as small as 700 kb.
-Caching: query outcomes are being cached so they aren't fetched double.
-Source code: source code is available too.