Free Open Source OLAP Software

Pentaho tightly couples data integration with business analytics in a modern platform that brings together IT and business users to easily access, visualize and explore all data that impacts business results. Use it as a full suite or as individual components that are accessible on-premise in the cloud or on-the-go (mobile). Pentaho Kettle enables IT and developers to access and integrate data from any source, and deliver it to your business applications, all from within an intuitive and easy to use graphical tool. Need help installing PDI? Access the installation guides for the following operations systems: Windows: https://www.hitachivantara.com/en-us/pdf/white-paper/pentaho-community-edition-installation-guide-for-windows-whitepaper.pdf Linux: https://www.hitachivantara.com/en-us/pdf/white-paper/pentaho-ce-installation-guide-on-linux-operating-system-whitepaper.pdf Mac: Coming Soon

JasperReports Server is a powerful, yet flexible and lightweight reporting server. Generate, organize, secure, and deliver interactive reports and dashboards to users with a web based BI Platform. Available as an open source community edition download as well as a commercially licensed, enterprise-grade business intelligence solution.

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.

OpenI plugin for Pentaho CE provides a simple and clean user interface to visualize data in OLAP cubes. It supports both direct Mondrian and xmla based connections like Microsoft SQL Server Analysis Services (SSAS), plus provides add-on features like Explore Cube Data, custom SQL for drillthrough data, publishing drillthrough data to external web services etc.

Palo ETL Server is a Java based Tool for Extraction, Transformation and Loading of mass data into the Palo OLAP Server. Palo ETL Server is one part of the Palo Suite.

Pretty Damn Quick (PDQ) analytically solves queueing network models of computer and manufacturing systems, data networks, etc., written in conventional programming languages. Generic or customized reports of predicted performance measures are output.

Creating beautiful dashboards and thousands of reports that can be embedded into your application can be easily done with Caxpy. Its a very lightweight application which can be used to create reports from just plain SQL queries.

LucidDB is a DBMS optimized for business intelligence. Besides architectural innovations such as column-store, it supports many advanced features from SQL:2003, including SQL/MED and user-defined transformations written in Java.

jdbc4olap is a ready-to-use JDBC 3.0 driver that provides access to OLAP databases. Relying on a relational representation of multidimensional environments, it includes a SQL-MDX converter and uses XMLA to dialog with OLAP servers.

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/

With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned, authorized and published. On the top of the A.A.A.R. solution, the A.A.A.R. Analytics is a set of powerful tools to analyze data in an interactive and customizable way with a user console composed by dashboards, reports and free analysis.

JRubik is a set of tools for navigating and reporting over OLAP Datasources, mainly Mondrian and XMLA servers. This project is based on the components developed by the JPivot project.

911 Call Tracker is a Java app that tracks 911 phone calls. It provides detailed reports of: calls per operator/answer times, abandoned calls/ring times, calls over answer limit and more. Provides real-time access to call info,TDD,address, and cell info.

Advanced Analysis Services is a Business Intelligence (BI) tool to let users analyze OLAP sources like Pentaho, Mondrian, Microsoft Analysis Services (MSAS) or Hyperion, in an intuitive way, based on analysis templates like Paretto, Ranking and BCG

AlphaMiner is an open source data mining platform that offers versatile data mining model building and data cleansing features with an user friendly workflow interface.

We want to build OLAP analyzing tool for multi-dimensional data analysis.

AMSF (Automated Model Selection Framework) provides Classifier/Predictor Selection for WEKA-Classifiers based on Meta-Learning. Selection is done via a rule-based Pre-Selection, followed by 'Zoomed Ranking'(as used in WEKA METAL).

AxOlap. Some ready to use OLAP cube for Microsoft Dynamics Ax (Axapta)

The BEE Project is a suite of tools supporting Business Intelligence project implementation including ETL tool and OLAP server and a thin client. The ROLAP server ensures multipass SQL generation and powerful cache management (utilizes MySQL RDBMS).

BIOLAP - OLAP for Genome and Biology Data Sets. This project extends Mondrian OLAP to biology data sets. We provide tools to slice and dice genomic sequence similarities and more easily explore large genomic data sets.

Braque is an OLAP client for OpenRolap and JCrosstab. As planned it will be a web-based application with spreadsheet-like features, slice and dice, charting, reporting and downloading data.

Use Pentaho open source business intelligence tools and MySQL to collect & distribute web analytics (clickstream) data. Extract data from logs, load database tables, & present the information in dashboards, analysis cubes, and reports for business users. This project has been moved to github - https://github.com/cjlavigne/breadboard

Reporting solution that collects data from multiple MySQL databases and presents important metrics and reports related to performance and usage.

Chaman is a web-based, relational OLAP tool, built over Apache Cocoon.

ConDEnSE (Confidential Data Enabled Statistical Exploration) will be a web-based environment for statistical analysis of confidential data from various database sources, based on Plone and R, and using the Jackknife method of confidentiality protection.