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

Configuration and Permissions

Unanet AE relies on permissions to grant access to write and design queries for
Analytic Dashboards. You will need permission to the following applets that are involved
with Query building:

• Analytic Dashboard Designer
• Analytic Dashboards
• Dashboard Queries Manager
• Query Builder

Data Sources

Each Analytic Model relies on a data source for the data it contains. Analytic
Dashboards support both native (Unanet A/E) and third-party data sources - selected
when building the design. This means that, in addition to your Unanet A/E data, you can
now visualize outside data across other areas of business, making Unanet A/E a central
hub for business analysis.

Analytic Models (Dashboard Query Manager Applet)

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.

While users with SQL expertise can build an Analytic Model by writing the SQL query
from scratch, the Query Builder makes building Analytic Models accessible to users who
are unfamiliar with writing SQL.

There are two Query Builders within Unanet A/E. One is the Query Builder Utility, which
allows users to build SQL Queries using available datasets and save them as Analytic
Models. There is also a built-in Query Builder within the Analytic Dashboard Designer,
which builds local queries using available tables and views. Queries built using the built-
in Query Builder are available only for use on a single dashboard.

Lesson 1: Query Builder Overview ©2024 Unanet. All rights reserved. 8