Skip to main content
Pentaho Documentation

Create an MDX Query

You must be in the Data Source Configuration window to follow this process. You should also have configured a JNDI data source connection.

Follow this process to add a Mondrian cube definition (multidimensional expression) as a data source.

  1. At the bottom of the Data Source Configuration window, click Use Mondrian Cube Definition (MDX). The Browse button will become active.
  2. Click Browse, navigate to the location of your cube definition file, click to select it, then click Open.
  3. Type an MDX query into the Query pane on the right.
  4. Click OK.
Your data source is now properly configured and refined according to the Mondrian definition you specified.