Skip to main content
Get SupportPentaho.com
Menu ▼
Pentaho Documentation

Create an MDX Query

  1. Last updated
    21:32, 2 Feb 2016
  2. Save as PDF
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.