Skip to main content
Pentaho Documentation

Create an MDX Query

For Pentaho Analysis data sets, such as OLAP and OLAP (Advanced), you can create MDX queries in the Pentaho Report Designer by specifying a Mondrian cube definition schema file.

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

Perform the following steps to add a MDX query:

  1. In the Data tab of the Report Designer, right-click on Data Sets and select one of the following options to access the Pentaho Analysis Data Source Editor window:
  • OLAP > Pentaho Analysis
  • OLAP > Pentaho Analysis (Denormalized)
  1. Specify a Mondrian cube definition schema file for Pentaho Analysis Schema File. You can use the Pentaho Schema Workbench to create this file.
  2. Select your data source in the Connections pane on the left, then click the round green + icon above the Available Queries pane on the right.
  3. Type a concise yet sufficiently descriptive name for your query in the Query Name field.
  4. Type an MDX query into the Query pane on the right. See About Multidimensional Expression Language for more information on MDX.
  5. Click Preview to view the unformatted query results.
  6. Click OK to finish working on the query.