General

The following fields are general to this transformation step:

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 connection to a database you want to query. Click Editto modify an existing database connection, Newto set up a new database connection, or Wizard to open the Database Connection dialog box.
MDX Query	Specify an MDX query to define a result set and retrieve data. An example query displays in the MDX Query area. The cursor position displays immediately below 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. Click Browse to select the Catalog location.
Role	Specify a role to use for access control. You can specify multiple role names separated by commas. If a role name contains a comma, escape the comma using an extra comma. When using multiple roles, the queries in the connection execute with the sum of the privileges of all the roles.