| Term |
Description |
|
Aggregate Function |
Functions (often mathematical) that can be used across sets
of data |
|
Columns |
The Expressions selected to be displayed in a report |
|
Comparison Method |
The operator used by a Filter or Parameter for comparison for example,
Equal To, Greater Than, Like |
|
Comparison Value |
A value that is used by a Filter or Parameter to refine the
rows of data returned to a report |
|
Data Connection |
A set of information sufficient for establishing database connectivity
to a chosen data source |
|
Data Container |
A published Table, View, Stored Procedure or Dataset
(based on a join) that can be used to source data for a report |
|
Data Expressions |
A Field or Expression (derived from one or more fields) in
a Data container |
|
EUQR |
End User Query and Reporting, a niche category of the Business
Intelligence market |
|
Filters |
Static criteria used to limit the data that is returned by
a report |
|
Filter Field |
The Expression on which a Filter is defined |
|
Join |
A way of relating the data in one or more tables so that the
data can be viewed as a single set |
|
Metadata Set |
A set of data that describes another underlying set of data
for the purpose of simplifying access to the underlying data |
|
Object Window |
The explorer style interface used to access Sage Intelligence Reporting
Objects |
|
ODBC |
Open Database Connectivity. A universal standard for database
access |
|
Optional Defaults |
Used as default parameter values at actual report runtime |
|
Parameter |
User specified (at runtime) criteria used to limit the data
that is returned by a report |
|
Data Screen |
A screen that provides a read only view on sample data |
| Process Monitor |
Tool that displays all running reports and that allows reports
to be cancelled |
|
Progress Status |
Window that shows the running state of a report |
|
Source Container Type |
The source of the data needed to generate reports |
|
Table |
A structure for storing data |
|
View |
A view is a virtual table whose contents are defined by a query |
|
Stored Procedure |
A pre-compiled selection of SQL statements and optional control-of-flow
statements stored under a name and processed as a unit |