Creating Queries

  To create queries:

1. In the Administration Workbench, go to the Presentation tab and select Queries.

2. Click Add and enter query details:

   • Name—Must be one word

   • Type—Custom, MDX, Overlay, or RSQL

   • Owner

   • Description

   • Max Rows

   • Execution Class Name—For custom queries, the Java class name used to execute the query

   • Definition—You can copy and paste the query definition from another source, such as a text file.

     Syntax requirements:

     • A comma is required after an ON COLUMNS statement only if it is followed by an ON ROWS statement.

     • You can place line breaks between keywords; however, do not place line breaks inside dimension member names.

     • A Parameter(...) statement is required in an MDX query for each filter menu in a report worksheet.

3. Click Preview to confirm query results and correct syntax errors.

   You can preview the query against base data or scenario data.

   See Previewing and Editing Queries.

4. Click OK.