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.

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.

  • No labels

1 Comment

  1. 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?