Free OLAP Tools 2015
Jedox
Jedox provides an excellent BI platform based on open source technology that is one of the most cost effective solutions in the industry. At the heart is an OLAP server, and many types of business data can be conveniently stored in this format. It is fast and exploits in-memory technology and various techniques (real-time aggregation and calculation) to provide sub-second responses to many types of BI query. An Excel add-in is provided.
<
icCube
icCube is a free end-to-end BI solution covering reporting and analytics. The reporting is designed for business users and facilitates exploration of OLAP data via reports, graphs and dashboards. Analytics include an ETL layer and support for multidimensional analysis and MDX+. XMLA is also supported for connection to other reporting tools (eg Excel), and support for R and Java means other forms of analysis can be carried out.
Mondrian
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.
JMagallanes
JMagallanes is an end user application for Olap and Dynamic Reports written in Java/J2EE. It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports.
JsHypercube
JsHypercube is a light-weight OLAP database written in JavaScript. It is useful for any application involving the aggregation of metrics for purposes of dynamic charting. Datasets can be “sliced and diced” in real-time, with low-latency.
Kylin
Kylin is an open source Distributed Analytics Engine from eBay Inc. that provides SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets. It currently offers integration capability with BI Tools like Tableau. Integration with Microstrategy and Excel is coming soon.
olap4j
olap4j is a common API for any OLAP server, so you can write an analytic application on one server and easily switch it to another.
Pentaho Community
Pentaho can be hosted on various cloud services including AWS and Rackspace, and provides the same broad functionality as on-premise deployments. This includes reporting, dashboards, OLAP, data mining, ETL and other functions that complete the analytics picture.
phpmyolap
phpmyolap – OLAP application in PHP for MySQL databases. No java-based web service needed. No MDX language to use.