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.
Description
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 mondrian.properties file. Place this file into data-integration/lib or another location in your classpath.
Options
Option | Description |
|---|---|
Step name | Name of the step; this name has to be unique in a single transformation |
Connection | 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. |