Open Source Java 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.

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.

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.

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

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.

Please us FREEANALYSIS Project On SourceForge for last releases - FreeOlap (now FreeAnalysis) is a complete java (Eclipse RCP) and Web (Apache Shale) application that provide Olap functions against leading Mondrian Olap Server. FreeOlap audience are user

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.

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.

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.

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.

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.

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

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

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

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.

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

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.

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.

Open Source Web-based Business Intelligence platform

An open source OLAP tool for MySQL. OpenOLAP for MySQL has both R-OLAP and M-OLAP functions. The team from Nomura Research Institute, Ltd. has migrated OpenOLAP to work with MySQL5.0.x. since original version of OpenOLAP had worked only with PostgreSQL.

Jira and Bugzilla reporting solution that provides useful software quality metrics, reports, and analysis. Track progress and metrics historically.

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.

A Flex/java based system for presenting statistics over the net. Based on Mondrian backend. Able to handle large amounts of data, administration facilities not worth shouting about.

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.