Jaspersoft OLAP Schema Workbench

The Mondrian Schema Workbench allows you to visually create and test Mondrian OLAP cube schemas. This guide helps you to create your first OLAP schema. It uses FoodMart data source, a MySQL database example provided when installing JasperReports Server.


  • Java 1.5.
  • JDBC driver for your database in the drivers directory.

Starting the Workbench

  1. Start the Workbench by running workbench.bat (Windows) or workbench.sh (for Unix/Linux).

Database Connection

  1. See Adding a Database Connection.

OLAP Schema

  1. See Creating an OLAP Schema.

MDX Query

  1. See Testing MDX Query.

See also...