Facts table

This code identifies the current record in a unique way.

It corresponds to the name of the table that will be created in the datamart database.

The table abbreviation must be composed of 1 to 4 characters (letters or numbers but must start with a letter). It is the unique identifier for all the table abbreviations of the data dictionary. The Adonix reserved words are prohibited.

An activity code is used to:

• Make an element optional in the dictionary if the value associated with the activity code is null
• Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z
• Size a maximum number of lines when the activity code marks elements from a grid

If the activity code is disabled:

• The marked element will not be useable
• The associated code will not be generated nor activated

If this box is checked, a filtering by site can be made on the data in the facts table. This assumes that a site field exists in this table.

The access rights for the site in the reports will be determined by means of a function code managing the data filtered by site : the sites authorized for the function in question for a given user will be assigned to the data in the report.

Mandatory if an authorization by site is defined, this field is used to define the site field code to be used to filter the data. It must correspond to a field defined in the tab Fields in the facts table. This field must in addition be of the type FCY.

This date type field is used, where it exists, to base any purging of the facts table from this date.

Number of information detention days. The superior data will be purged as that calculated date.

This field defines if the loading logic for the facts table must be :

• of the type Incremental (on each triggering, the modifications to the source table are copied, which have been logged with the help of a database trigger)
• or of the type Delete and replace (all the lines in the table are deleted prior to completely recreating them).

If this box is checked, an object that is used to count the number of lines in the facts table is created in the universe.

Defines the code for the field in the facts table or the table describing dimensions. This code is that under which the field is known in the database (it is automatically suffixed with the characters "_0"). It is not visible when in the management reports (it is the title that is displayed) but can be viewed if looking at the SQL syntax that extract the data from the datamart.

The field type is defined here, which characterize the entry format (numeric, any characters, date...) and the coherence controls (reference to a table for example).

The principal generic types that exist :

A : Alphanumeric
C : Short integer
L : Long integer
DCB : Decimal
D : Date
M : Local menu
MM : Local menu with filter
ACB : clob
ABB : blob

But many other predefined types exist. They often make reference to an annex table (currency, country...). A dedicated dictionary is used to described them and they can be selected using the key that is used to obtain the list.

In the case of the facts tables, it is necessary to enter the additional information for certain types (dates, miscellaneous tables, local menus).

Used to define the length of a field when this field uses a generic data type where the length is not fixed. This is notably the case for the types A and DCB.

When a field from the facts or dimensions table is of the type date and is defined as dimension, it is automatically associated with a dimensions table named AX3DAT, which is automatically managed.

It is then possible to specify here what are the time characteristics linked to the date that will be accessed in the analyses. A list of characters to be defined is given, not forgetting there are the following correspondences :

• Y=year
• S=half year
• Q=quarter
• M=month
• F=fortnight
• T=decade
• W=week
• D=day

Thus, for example, YMW signifies that a direct access is available for the year, the month and the week defined by the date.

Defines the local menu number associated with the field defined on the line.

When a field is of the type local menu (from 1 to 255) corresponding to the rank of a title in a table named local menu, stored in the messages table APLSTD.

On entry or on display, the following are displayed according to the choices made in the user interface :

• either a title can be chosen in a scrolling list commonly called a combo box
• or a list of buttons.

The interest of this type of entry is that the list of choices is displayed in the user connection language.

Each local menu number characterises the list of available titles. For example, the local menu 1 corresponds to the choice No / Yes in this order. In this particular case, the user interface can also be a check box.

If the field is associated with a miscellaneous table, the number that identifies it is defined here.

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).

Used to specify if a count of the number of lines available is required by criterion value. A measure of the account type is then created, to optimize the corresponding access.

An activity code is used to:

• Make an element optional in the dictionary if the value associated with the activity code is null
• Identify the specific/custom elements if they are marked with a code starting with X, Y, or Z
• Size a maximum number of lines when the activity code marks elements from a grid

If the activity code is disabled:

• The marked element will not be useable
• The associated code will not be generated nor activated