Pivot4J provides a common 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's codebase to make it a general purpose OLAP API library which is independent of any particular GUI implementation.
Please visit Pivot4J home page at http://www.pivot4j.org