...
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.
- Role - The Mondrian role to use with the connection.
...
- 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
...
...
...
- action for further details
...
Mondrian Schema File - The location of the Mondrian schema file. This is only needed when using a JDBC or JNDI connection.
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
...
- Pentaho Report action
...
- .
*Result Set Name*
- The name of the resulting output dataset. Following actions can refer to the data set using this name.