Mondrian is an OLAP (online analytical processing) engine written in Java. It reads from JDBC data sources, aggregates data in a memory cache, and implements the MDX language and the olap4j and XML/A APIs.
OLAP application in PHP for MySQL databases.
No java-based web service needed.
No MDX language to use.
Download FooodMart Database for MySQL
http://pentaho.dlpage.phi-integration.com/mondrian/mysql-foodmart-database
On line demo and information at http://phpmyolap.altervista.org/
OpenDigger is a java based compiler for the xETL language. xETL is a language specifically projected to read, manipulate and write data in any format and database. With OpenDigger/XETL you can build powerful Extraction-Transformation-Loading (ETL) progs!