The Latitude Query Language (LQL) is designed specifically to
query and manipulate data from an MDEX Engine. LQL is used to support all of
the search and navigation functions in Latitude Studio.
Power users also need to be able to write LQL statements in order to
generate the data to display for the following components:
- Alerts
- Chart
- Cross
Tab
- Metrics
Bar
- Results
Table
LQL is very similar to SQL, and includes support for:
- Aggregation functions.
- Numeric functions.
- Composite expressions to
construct complex derived functions.
- Grouped aggregations such as
cross-tabulated totals over one or more managed attributes.
- Top-k according to an
arbitrary function.
- Cross-grouping comparisons
such as time period comparisons.
- Intra-aggregate comparisons
such as computation of the percentage contribution of one region of the data to
a broader subtotal.
