Overview
Analytic Models (or queries) are used to feed dashboards designed with the Analytic Dashboard Designer. Generally, models are written for performing business analysis and should be written with the end user in mind (e.g. using decipherable return names, etc.). In addition to the query, you can leverage Parameters, Field/List Descriptions and Permissions.
Query Builder makes building Analytic Models accessible to users who are unfamiliar with writing SQL.
Tutorial
| 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 |
| 7. | Once satisfied with the results, click Copy |
| 8. | Browse to UT>Dashboard Queries Manager |
| 9. | Select Analytic Model from the query type drop-down |
| 10. | Click + New Analytic Model from the toolbar |
| 11. | Paste in the copied query |
Your Analytic Model will now be available for use in the Analytic Dashboard Designer.
|