Field help (ABFTYPFLD)

Used to characterize the data in the facts table. The following values are possible:

• Measure assumes that the field is numeric. This type of field can be aggregated on the dimension combinations in the analysis reports, notably in order to obtain the totals, the minima, the maxima on the aggregates.
• Dimension signifies that the field is considered as a analysis criterion. In principle, it is linked to the dimensions table that is used to store the values and to associated them with other characteristics In certain cases (the fields of the type date, local menu, miscellaneous table) the dimension table is implicitly manage by the software package.
• Information corresponds to a field that will be presented in the reports, but it is not considered as being descriminant from the point of view of the analysis and the data aggregation.
• Technique corresponds to the fields that are used in the data structure (for example to define the links), but which do not need to be visible when constructing the reports.

It should be noted that a field of the type ACS (access code) is automatically defined as technical (it will not appear in the description of the fields in the facts table, but will be used to filter the data when used for queries in the facts table).