Free OLAP Tools 2015
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 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 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 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.
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 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 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 – OLAP application in PHP for MySQL databases. No java-based web service needed. No MDX language to use.