When you begin working in Apricot Results, you will begin to see and hear some unfamiliar words and phrases. This article will help you learn the definitions for some of the more common results objects.
Column: All of the data in a vertical line within a table.
Details: These appear as green diamonds and represent fields within an object.
Dimension: Appear as blue parallelograms. Data that is representative of something in Apricot.
Filters: Appear as inverted orange triangles. These allow the user to narrow data results.
Flattened Data: Data stored in individual records. Flattened data should be used when reporting on specific answers to questions. In some cases, flattened data is not updated live.
Formula: Logical equation that is used to calculate values and manipulate data in a report.
Inflated Data: Data that may be duplicated within a report.
Measures: These appear as orange rulers. They are grouped data based on dimension data in a universe.
Merged Dimension: An Object created within a report that connects multiple queries together using a common field/dimension.
Object: Any data point that exists within the report.
Prompt: When a user is asked to enter a value upon opening a report, this is called a prompt. A user can be prompted for any object in a universe - date, name, program, record name, etc.
Queries: Tells a report what data to bring into the report. A report can have multiple queries to include different data from a universe, or data from different universes.
Row: All of the data in a horizontal line within a table. Typically, a row will contain all of the data for a single record and a column will contain all of the data for a single piece of information (all names, all dates of birth, all answers to a record fields, etc.) but this is not always the case.
Row Aggregation: Identical values that may have been condensed by WebI into a single value.
Unflattened Data: All data in an enterprise stored in "Question/Answer" pair format. Unflattened data should be used when aggregating (totaling) data. Unflattened data is always updated in real time.
Universe: This is where the data in the report is being retrieved from.
Variable: Any object created within the report, usually by way of a formula.