Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
title:Warning
title:Warning
borderColorblack
bgColor#ffff00
borderStylesolid

(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.

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.