Query Builder

Click this icon to view and amend the existing query for the active cube.

Use the Query builder to assist in creating your query. Here you can

Double click on the table name to add the table to your query
Select the columns required by clicking on the tick box to the left of the column name or type the column name in the expression box
Type in the aggregate function (if required)
Type in an Alias (if required)
Select Sort Type and Sort Order and Group by if required
Test the query by clicking on the data tab to view the results
To join tables, click on the column in the first table and drag to the second table. The join type can be amended by double clicking on the line joining the tables
Type in functions (for example Rtrim) in the Expressions window
When complete, click File > OK and the new cube will be created in the workbook
The SQL query can also be typed and amended in the SQL Pane