Tutorial
Below is a brief tutorial for building a query with Query Builder.
| 1. | Browse to UT>Query Builder |
| 3. | Select fields for use in the query form the Available Fields list |
| a. | Add Calculated Columns and/or Filters as appropriate |
| 6. | Review the Results from the Results tab |
Once satisfied with the Results, the query can be Copied or Exported (to a .sql file) for use in other InFocus applets such as:
| • | Dashboard Queries Manager - Used for building Classic Dashboard widgets and Analytic Models |
| • | Custom Reports - Used for building customized reports |
| • | SQL Query - Used to write and run queries against a data source (typically InFocus). |
|