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 Edit to modify an existing database connection, New to 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. |