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.

Pivot4J also provides a fully functional OLAP analytics application built on top of its core library, along with a plugin for Pentaho BI platform which can be installed directly from the marketplace.

Read more…


  • Supports most of the original JPivot’s features, like drill down, drill through, sort, and more.

  • Supports any OLAP backend for which an Olap4J driver implementation is available.

  • Mavenized project structure with flexible and easy to use API.

  • Clean separation of UI and backend, which enables you to build your own OLAP client with UI toolkit of your choice.

  • Non-MDX based aggregation(a.k.a. ‘visual total’).

  • Powerful formatting support based on MDX independent expression language.

Project in maintenance mode

Currently, the project is in maintenance mode and in need of a new maintainer to continue the development.

You can read the official announcement here, and please leave a message at the support forum, if you are interested in taking over the project as the new maintainer.

Pivot4J 0.9 is released (May 25, 2014)

After 9 months of development, Pivot4J 0.9 is released with many new features and bug fixes. Some of the highlights of the new release include :

  • Charting support with customizable axis mapping feature (click here for a demo).

  • Dutch, French, German, Hindi, Italian, Russian, Spanish translations, thanks to the Pentaho Community translation team.

  • Embeddable URL support and basic Pentaho CDE integration.

  • Many important bug fixes for enhanced security and stability.

For full list of changes, please see the changelog here.


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

Back to top

Last Published: 2017-10-15 07:14:00.

Reflow Maven skin by Andrius Velykis.