Mondrian Input

The Mondrian Input step reads data from a Mondrian cube using a Multidimensional Expression Language (MDX) query and a Mondrian schema description (catalog).

You can create Mondrian schemas using Pentaho Schema Workbench. For information about configuring the mondrian.properties file, see Mondrian configuration. Place mondrian.properties in the data-integration/lib directory or another location on your classpath.

Mondrian Input dialog

General

Field	Description
Step name	Specify the unique name of the Mondrian Input step on the canvas. You can customize the name or leave it as the default.
Connection	Specify the database connection to query. Select Edit to modify an existing connection, New to create a new connection, or Wizard to open the Database Connection wizard.
MDX query	Specify an MDX query to define a result set and retrieve data. An example query appears in the MDX query area.
Replace variable in script?	Select to replace variables in the MDX query before sending the query to the database.
Catalog location	Specify the path to the Mondrian schema file. Select Browse to choose the catalog location.
Role	Specify a role to use for access control. You can specify multiple roles separated by commas. If a role name contains a comma, escape it with an extra comma. When you use multiple roles, queries execute with the combined privileges of all roles.