About

Pivot4J provides a common Java API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI. It aims to leverage mature but now discontinued JPivot project's codebase to make it a general purpose OLAP API library which is independent of any particular GUI implementation.

Motivation

For a long time, JPivot has remained as a de facto standard for creating a pivot grid style OLAP frontend application in Java language. However, as the project is no longer actively maintained for now, advance of new web technologies has made its JSP-based approach look quite outdated.

Moreover, JPivot was never designed as a common API for OLAP even it included lot of useful backend implementations for connecting to and work with XMLA and Mondrian servers.

As many BI developers felt the need for more modern and generic API for OLAP in Java, Olap4J has emerged as a combined effort by various commercial and open source projects to fill this gap.

Pivot4J project has been started as a fork and major refactoring effort of JPivot to combine the best parts of both libraries. It replaced JPivot's legacy backend implementation with Olap4J while leveraging its mature query transform API. And also Pivot4J has done extensive refactorings to make its codebase more modern and maintainable.

Pivot4J itself does not mandate to use any specific technology to build an UI application with it. Rather. it's designed as an easy to use model and abstract UI layer for creating such applications using any technologies like JSP, JSF, GWT, or even client side graphical toolkits like SWT or Swing.

Features

• Supports most of the original JPivot's features, like drill down, drill through, sort, and more.
• Supports any OLAP backend which has an Olap4J driver implementation available.
• Easy to use and very extensible renderer API including a concrete base implementation for web applications.
• Built-in PDF and Excel exporters.
• A fully functional sample application based on Java Server Faces.
• Visual total(non-MDX aggregation) support.
• Parameterized MDX support.

News

• [2012-04-14] Pivot4J 0.7 has been released. Visual total and expression language support was introduced with this version. Also, Brazilian Portuguese translation is done by IT4Biz and Professor Coruja Team.
• [2013-02-02] Decided to bump the version a little bit, so instead of 0.0.6, Pivot4J 0.6 has been released. New features include PDF, Excel export support, and public MDX parser API. And we no longer maintain a separate homepage for the sample application project.
• [2012-11-18] Pivot4J 0.0.5 has been released with new features and various bug fixes! The new command API brings buit-in drill down and sorting support to PivotRenderer interface.
• [2012-10-28] Pivot4J 0.0.4 has been released. The rendering API has been re-implemented from the scratch to make it more flexible and easier to extend.
• [2012-10-20] Pivot4J 0.0.3 has been released with various bug fixes and some new features. Please see the changes note for details.
• [2012-10-08] Pivot4J 0.0.2 has been released with the new table builder API.
• [2012-10-07] A JSF based sample application is now available! It's called Pivot4J JSF, and has a separate project page here.
• [2012-09-28] Pivot4J 0.0.1 has been released. You can download it from here.

Contact

If you have any question or suggestion for the project, please leave your message at the support forum.