Query Properties

Use the Properties page to specify the database, into which the query and the query text is to be placed.

Determine the following parameters on this page:

  • Query to Database. Create a query to database in the SQL language according to the syntax that is set for the selected DBMS driver.

The selected DBMS driver and the driver list are displayed next to the Query to Database field. By default, the driver list displays the selected driver used during repository connection setup. If query is specified for one or several drivers, the selected driver(s) will be marked in the driver list.

To show or hide the driver list, use the Hide Driver List/Show Driver List button.

Click the Check Query button to check if the created query is correct.

To set the specified query to database for all DBMS, click the Apply for All DBMS button. The confirmation dialog box opens. If query is specified for at least one driver that is different from the current one, all the specified queries will be replaced with the current one if the answer is positive.

    • Detect Table Automatically. When the radio button is selected, after clicking the Save button, the table to save data is automatically determined on the last page of the wizard. If the table is failed to be determined, the appropriate message appears:

      • Clicking the Yes button saves the query.

      • Clicking the No button cancels all the changes, the query creation wizard is closed.

      • Clicking the Cancel button closes the message.

    • Determine Table Manually. Set the table to save data in the edit box.

To finish the wizard, click the Save button, after which the query is saved. The following actions are executed on saving a query:

Determine the following parameters on this page:

NOTE. To use subqueries in a query-based cube, select the Use Subqueries when Retrieving Data checkbox in the standard cube wizard.

To finish wizard's work, click the Finish button, after which the query is saved. The following actions are executed on saving a query:

See also:

Query