Please enable JavaScript.
Coggle requires JavaScript to display documents.
BAM Queries (Continuous Query ((Duplicate detection template) (Fetches…
BAM Queries
Business Query / Query
request for data that match specified conditions. A query can fetch from a data object once, on a schedule, or continuously.
Flat Query
Def: a simple table of data fields and their values. You select the data object and then select the data fields.
-
Sends to/ Vew: List, Action List and Geo-Map views only
Group SQL Query
Def: is an analysis of one or more numeric data fields, called measures, grouped by non-numeric data fields called dimensions. For example, a group SQL query might analyze cases grouped by department. You select the data object and then select the measures and dimensions.
-
Sends to/ View: All views except List, Action List and Geo-Map, treemap, KPI watchlist
Tree Model Query
Def: is an analysis of one or more measures grouped by a hierarchy of dimensions. For example, a tree model query might analyze cases grouped by Judicial system, Department, Team and Employee. You select the data object and then select the measures and a hierarchy.
-
-
Continuous Query
Def: an analysis of data collected in real time. For example, a continuous query might fetch the call volume for a call center every ten minutes. There are multiple continuous query templates, which perform these analyses. Continuous queries are written in Continuous Query Language, or CQL. Unlike SQL, which operates on data in a database or cache and responds to client requests, CQL operates on data in-memory and pushes the results to clients
-
-
-