Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

(warning) PLEASE NOTE: This documentation applies to Pentaho 8.1 and earlier. For Pentaho 8.2 and later, see Mondrian Input on the Pentaho Enterprise Edition documentation site.


This step reads data from a database using a Mondrian schema description (Catalog) and an MDX query.

Note: Please see the Mondrian Configuration for configure how it executes via a file. Place this file into data-integration/lib or another location in your classpath.




Step name

Name of the step; this name has to be unique in a single transformation


This defined the connection to the database.

MDX Query

This is the MDX query processed by Mondrian.

Replace variable in script?

When this option is checked, any variables in the MDX query will be replaced before sending to Mondrian.

Catalog location

This defined the path to the Mondrian schema description.

  • No labels

1 Comment

  1. user-71950

    Is it possible to use a field instead of a variable in MDX Query area? Is there a way to get the value of a field as a variable inside the Transformation?