Hitachi Vantara Pentaho Community Wiki
Child pages
  • Evaluating Pentaho Analysis

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


This document contains instructions and information that helps you evaluate Pentaho Analysis using your own data. This document must can be used with the current version 1.6 of the Pentaho Open BI Suite, version 1. 6. It is assumed that you are familiar with the Pentaho Design Studio and the Pentaho BI Platform. Please note that after you create the schema following these instructions, you can easily create a Pentaho Analysis View in the latest 1.7 GA release using the web base interface available in the "Go" menu item of the PCI. That means you do not have to use the Pentaho Design Studio to create the initial view. However as you become more advanced with the Pentaho Platform you can use the Pentaho Design Studio to edit the MDX created by the Pentaho Analysis Viewer and create some comprehensive dynamic analysis views.

Pentaho Analysis is built on the popular Mondrian OLAP engine. The Pentaho BI Platform embeds the Mondrian engine as part of its architecture. Along with the Pentaho BI Platform, the Mondrian engine processes MDX requests with the ROLAP (Relational OLAP) schemas. These schema files are XML metadata models that are created in a specific structure used by the Mondrian engine. These XML models can be considered cube-like structures which utilize existing FACT and DIMENSION tables found in your RDBMS. It does not require that an actual physical cube is built or maintained; only that the metadata model is created. The structures and related API are outlined in the Mondrian Technical Guide that accompanies the Mondrian distribution as well as the Schema Workbench.