Welcome. OpenI is a web-based OLAP reporting application. OpenI is an out-of-box solution for building and publishing reports from XMLA-compliant OLAP data sources such as Mondrian Microsoft Analysis Services or Mondrian. With version 3.0 OpenI is deployed as a plug-in on top of Pentaho or Jasper.

Current Version

OpenI Plugin for Pentaho

The OpenI plugin for Pentaho 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 OpenI specific features like Explore Cube Data, custom drillthrough, adding analysis to dashboard directly etc.
  • Current Version: openi-pentaho-3.0.1
  • Status: Released
  • Demo:

    Demo: OpenI plug-in for Pentaho

OpenI Plug-In for i2b2

OpenI plug-in provides a better UI for querying and downloading patient data from i2b2.

i2b2 (Informatics for Integrating Biology and the Bedside) is an NIH-funded scalable informatics framework. It enables researchers to use existing clinical data for discovery research and has wide international adoption.. It consolidates various clinical and biological (including genome) data and allows mapping to standard metadata. Once clinical research data sources aggregated into i2b2 framework are mapped to standard “ontologies”, i2b2 provides a web-based query interface to get patient counts matching various medical/biological conditions defined using standard terminology.

OpenI plug-in essentially integrates its business intelligence dashboard and reporting features to i2b2 data set. This way, instead of issuing queries one by one to find potential patient cohorts for a research, users get more of a "top down" view of the data, which they can slice and dice visually, and perform ad hoc anlaysis without having to write their own queries.

  • Current Version: openi-i2b2-1.0
  • Status: Released
  • Demo:

    Demo: OpenI Plug-In for i2b2


  • OpenI-Jasper Alpha
    • October 2010 - February 2011
    • Replaced JPivot based JasperAnalysis UI with OpenI's UI


The final release of OpenI as a standalone platform is 2.0-RC2 (released on September 4, 2009), and can be downloaded from sourceforge.net
We have discontinued working on this release and encouraging users to migrate to using OpenI as a plug-in for Pentaho or Jasper.

Quick Start:

Road Map

See the Releases page for all current and previous release details


 We are always looking for contributions of any kind: code, documentation, requirements, feedback, testing. Take a look at the Contribute page.

Wiki posting guidelines

 This wiki is intended as place to hold up to date documentation for the OpenI community. Discussions should continue on the Sourceforge OpenI forums. Even though there is a discussions feature on this wiki, it's use should probably be limited. And discussions should be minimized in main wiki article content.