The Most Widely Used Open Source Business Intelligence
Jaspersoft provides a range of data analysis options including on-the-fly in-memory analysis built directly into the report server, along with a powerful high-volume and historical data analysis engine delivered by a relational OLAP server. The Jaspersoft Analysis Portfolio includes:
| In-Memory Analysis with JasperServer | OLAP Server with JasperAnalysis | Excel OLAP Connector with Jaspersoft ODBO Connect |
![]() |
![]() |
Jaspersoft's In-Memory Analysis capability within JasperServer lets business users explore their multi-dimensional data – pivoting, drilling, sorting, and filtering – without the overhead of a data warehouse or traditional MDX-based OLAP technology. The in-memory analysis service can be configured to leverage either high-performance in-memory processing, or highly-scalable DBMS processing of analysis operations.

JasperAnalysis provides a powerful, web-based online analytical processing (OLAP) capability so business users can explore data to discover causes, spot trends, patterns, anomalies, and visualize correlations. It does the heavy analytical lifting that would be either too difficult or too expensive to perform using standard SQL-based query and reporting.
JasperAnalysis contains built-in aggregate awareness to speed performance against large data volumes. It complies with de facto OLAP standards such as the MDX multi-dimensional expressions query language, and XMLA.

The Jaspersoft ODBO Connect utlility combines the familiarity of Microsoft Excel with the power and flexiblity of an OLAP engine. With data stored inside JasperAnalysis, users can interact with their data using Excel. Slice, dice, and analyze against a centralized data store using an comfortable and familiar interface.