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/

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.

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.

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.

olap4j is an open Java API for connecting to OLAP servers and writing analytic applications. Code is at https://github.com/olap4j/olap4j.

OLAP aggregation engine with MDX support, web interface (slice & dice) and relational database backend. See "Documentation" for more. Presentation: http://cubulus.sourceforge.net/. See online demo courtesy of Webfaction, http://alxtoth.webfactional.com

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.

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.

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.

Information manager based on 3D cubes of knwoledgments. You can create a cube with 3 axis (or dimensions), each of them with several elements. The nexus between the elements of three axis compounds a value. From a cube, you can create 2D view queries

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

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.

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.

DATAPTURE offers a novel way for creating Database driven PHP sites with a minimun programming. Simplify SQL queries, Intuitive Content Management System (CMS). Session Management. Enhaced XML and JSON data exchange.

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

We have develop data mining 'Plug and Play' WYSIWYG Tool on commercial ERP Baan IVc4 which uses Baan 4 GL as extract and transform engine and MS excel as load client . For more information about the tool and the company , please visit www.erpjewels.com

Billing system solution. Library for credit card/ACH processing, recurring billing and subscription management for member and donor centered organizations. Provides a way for POS / retail / recurring credit card and bank account processing.

JBAM is open source Business Activity Monitoring system based on J2EE technology. Able to work with any commercial/non-commercial workflow engine, because of its generic architecture

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

JSMuDIT (JavaScript MultiDimensional Interactive Tables) builds tables with several (hierarchical) dimensions the user can dynamically interact with and customize using drilling, slicing, dicing, expand/collapse, sorting, color-coding, etc.