Open Source OLAP Software

Pentaho couples data integration with business analytics in a modern platform to easily access, visualize and explore 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 enables IT and developers to access and integrate data from any source and deliver it to your applications all from within an intuitive and easy to use graphical tool. The Pentaho Enterprise Edition Free Trial can be obtained from https://pentaho.com/download/

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/

The PalOOCa Project offers a fast, flexible and intuitive Office-based Business Intelligence solution based on Jedox. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Jedox OLAP Server via Calc. If used together with the Open Source Jedox/Palo OLAP Server it completes the Open Source MOLAP-Stack for Business Intelligence. Additionally to Jedox OLAP it is also (read-only) compatible to (almost) all OLAP servers supporting XMLA. Intended audiences are: - scientific research & teaching - financial analysis & controlling Consult the FAQ in the Wiki.

Comprehensive & high performance data distribution &transformation system. Features a simple, user-friendly event driven scripting interface transparently generates & execs highly efficient Perl/C code. Uses:ETL,datawarehousing,statistics,data-cleansing.

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

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.

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.

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).

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

DeciGen® is an ERP with added features for help in decision making process. DeciGen incorporates Decision Support System over an framework of ERP to provide a feature rich solution. It aims to achieve the final goal of IT - to run business smoothly. Dec

A Windows multithreaded application written in C#.Net designed to provide automated discovery and processing of various forms of source data. Each feed can be processed according to a basic syntax. All input parameters are defined by XML.

FreeAnalysis is a complete java (Eclipse RCP) and Web 2.0 (Dojo) application that provide Olap functions against Pentaho Mondrian Olap Server and other MDX/XMLA compliant cubes datasources such as Microsoft Analysis or Hyperion.

HydraCube is a highly scalable multi dimensional aggregation (OLAP) engine which supports MDX queries for data retrieval. It is a parallel software and can be run on network of wrokstations or multi processor shared memory systems.

JMagallanes is an open source end user application for Olap and Dynamic Reports written in Java/J2EE. Combines static reports, pivot table and charts. It reads from SQL and other data sources.

The JasperSoft Business Intelligence Suite provides integrated reporting, analysis, and data integration to make faster, better decisions. * Integrated or stand-alone * Analytic & operational data integration * Embeddable with ERP or CRM

La_Azada is an OLAP client developed in java (Eclipse Rich Client Application), and based on olap4j. Supports mondrian and XMLA drivers.

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.

MiningMart is a graphical tool for transforming data from relational databases. It provides two dual graphical views on the transformations, a data view and a process view. The focus is on the preparation of data for data mining.

Longname:Operational data business express---- ODBExpress is a report suit for business intelligence, it includes reporting, analysis (OLAP),etc.

OFBiz Datawarehouse Componet The aim of the project is to provide nice tools for datawarehouse creation, management and using; to implement OLAP tools for real-time analysis of large quantities of data. This component is for OFBiz (http://www.ofbiz.org)

OLAP Query Designer is a fork of JRubik, and will incorportate an all new interface and query designer. I allows querying of OLAP Datasources like Mondrian, and is based around JPivot and the Pentaho project.

OLAP-SC is a business intelligence application for spend + savings transparency, strategic sourcing, procurement / purchasing controlling. IT provides an olap cube model, a relational db model and controlling reports. See: http://www.orpheus-it.com

OLAP mapper is an OLAP engine written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL. The main concept of application is based on the star schema visualization.

Google Web Toolkit-based tool for publishing user-friendly OLAP views, reports and dashboards. Uses Mondrian OLAP and a relational database as the back-end.