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

LESSON 3: BUILDING QUERIES IN THE ANALYTIC

DASHBOARD DESIGNER

Learning Objectives

Summarize how to build queries the Analytic Dashboard Designer.

• Identify the benefits of the Query Builder within the Analytic Dashboard Designer
applet.
• Explain how to build a query using the Analytic Dashboard Designer applet.

Purpose and Benefits

In addition to building queries in the Query Builder Applet, queries can be built directly
inside the Analytic Dashboard Designer. Instead of adding an analytic model, the built-in
Query Builder creates a local query, available only to the dashboard for which it is built.
This Query Builder uses tables and views to build the SQL Query.

The Data Dictionary Report in the Utilities module provides a list of available tables and
fields within each table.

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