Field help (ABFTYPDAT)

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.