SQL Query Builder Wizard

Tables

Select tables in the Available Tables panel and move them to the Selected Tables panel using Add and Remove in the middle.

To reorder the table selections, select a table in the Selected Table panel and click the up and down arrow buttons.

Prompts you to select tables from the relational data source, prescribed on the Enter SQL Query dialog box, for use in a SQL query.

Columns

Select columns in the Available Columns panel and move them to the Selected Columns panel using Add and Remove in the middle.

To reorder the Column selections, select a column in the Selected Column panel and click the up and down arrow buttons.

Prompts you to select columns from the relational tables for use in a SQL query.

Select Column Advanced

Displays the Select Column Advanced dialog box, enabling you to select a function call, compose an expression, or enter an alternative column label.

Filters

Click Add to enter a Where clause. Click each column cell and make a selection from the drop-down list.

Prompts you to define filter selections for the Where clause on the SQL query. To focus and diminish the query result set, you can define dimension criteria (filters).

Dynamic Text Labels

You can also employ the powerful dynamic text labels used by the Print function and the Custom Document Label component in your SQL expressions.

Select Distinct

Sets up the query to return only distinct rows; eliminates duplicate rows.

Groups

Select columns in the Available Group By Columns panel and move them to the Selected Group By Columns panel using Add and Remove in the middle.

To reorder the column selections, select a column in the Selected Group By Column panel and click the up and down arrow buttons.

Prompts you to define GROUP BY selections for the SQL query. Groupings sort rows based on column members but do not order the rows.

Sorting

Select columns in the Available Sort Columns panel and move them to the Selected Sort Columns panel using Add Sort Ascending and Add Sort Descending in the middle.

To reorder the Column selections, select a column in the Selected Sort Column panel and click the up and down arrow buttons.

Prompts you to define sorting criteria for the SQL query result set in Ascending or Descending order.

Sorting results are influenced by the order of tables, columns, and filters on their corresponding tabs.

Mappings

Enter the OLAP dimension name to the right of the relational column supporting drill linking.

Prompts you to define (or map) drill links to or from relational columns to OLAP dimensions in other documents.