Description

Performs relational database queries using MDX against a Mondrian ROLAP data source.
!sqlquery.png|align=center,thumbnail!

Inputs and Outputs

*Database Connection Type*
- Specifies the type of connection to be used to connect to the database.
* *JDBC*
- Connect using a standard JDBC connection. The following inputs must also be provided.
** *JDBC Drive*
- Name of the JDBC driver class to use when connecting to the database.
** *Database URL*
- The database connection URL.
** *User Name*
- The username to use when connecting to the database.
** *Password*
- The password to use when connecting to the database.
* *JNDI*
- Connect using the specified JNDI name. The following inputs must be provided:
** *JNDI Name*
- The JNDI data source name.
** *Role*
- The Mondrian role to use with the connection.
* *MDX*
- Connect using the specified MDX connection string.
* *Shared*
- Connect to the database using the named shared connection. See the [Shared Relational Connection] action for further details

*Query*
- The MDX query to be executed.

*Run Query*
- Determines when the query is to be executed. The options are:
* *Immediately*
- The query is run immediately by the Pentaho BI server.
* *From Pentaho Subreport*
- The query is prepared for execution, with the intention of being run later in the action sequence by a subreport within a JFree Report. See the JFree Report action for further details.

*Result Set Name*
- The name of the resulting output dataset. Following actions can refer to the data set using this name.