O'Reilly logo

Pentaho Analytics for MongoDB Cookbook by Harris Ward, Joel Latino

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Mondrian 4 cube

This recipe shows you how to create a Mondrian 4 cube. Basically, this is the second part, after the physical model. It is responsible for mapping the business side to the physical schema.

Getting ready

Open the schema created in the previous recipe in your favorite text editor.

How to do it…

Proceed with the following steps:

  1. Let's add the Orders cube to the schema by writing this line:
    <Cube name='Orders' defaultMeasure='Total Price'></Cube>
  2. In order to add the Product dimension, it's necessary to write the following lines in the Cube tag:
    <Dimensions> <Dimension name='Product' table='Orders' key='Product Code'> <Attributes> <Attribute name='Name' keyColumn='productName' hasHierarchy='false'/> <Attribute name='Product Code' ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required