Mondrian Input

(warning) PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit 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.