Page 22 - Unanet AE: Creating Analytic Models Using Query Builder

Filter Data

To filter data in the Query Builder, click the Filter… button. This opens the Filter Editor
dialog that allows you to build filter criteria:

Edit Query Parameters

The Query Builder allows you to add query parameters when creating a filter criteria. To
specify settings of added query parameters, click the Edit Parameters… button.

Customize SQL Query

After you add the tables, you can customize the automatically generated SQL query. To
do this, enable the Allow Edit SQL checkbox and edit the SQL query displayed in the
SQL pane.

For instance, you can add a WHERE clause to the SQL expression.

Note: If you edit the automatically generated query and uncheck the Allow Edit SQL
check box, your changes will be discarded, and the generated query will be restored.

Preview Data
The Query Builder allows you to preview data for the created SQL query. To do this,
click the Preview Results… button.

This opens the Data Preview window containing data returned after executing the
query.

LESSON 3: Building Queries In the Analytic Dashboard ©2024 Unanet. All rights reserved. 22
Designer