Field help (ABICLE)

A dimension table must have available an index where the key values that are used to establish a join between the facts tables or other linked dimensions. This field is used to define these characteristics.

This is where the list of fields that make up the index are entered. The fields are separated by a '+' if there are several fields (for example, in the sites table FACILITY there is a key whose definition is LEGCPY+FCY).

A descending sort field is preceded with the sign "-" (warning, it is used in the left list).

The first field that makes up the index is without a sign and is therefore ascending.