Refer to documentation Implementation
Presentation
The rule can easily be identified by a single code.
Close
Fields
The following fields are present on this tab :
| This code identifies the current record in a unique way. |
|   |
| This flag is used to desactivate a synchronization rule. A part of the data can be loaded. Warning: a synchronization will be need when the rule is reactivated. |
Close
Presentation
The way the data are extracted is defined in this tab.
This is carried out by describing:
It should be noted that a trigger record can lead to the update of several datamart records (rule of 1,N type); in this case, a variable can varyindex from 0 to N-1, N being the dimension of the trigger field associated to this rule.
Close
Fields
The following fields are present on this tab :
Characteristics
| An activity code is used to:
If the activity code is disabled:
|
|   |
| Defines the principal table from which the data is extracted from the current folder to load the lines in the datamart. |
| Title associated with the previous code. |
| Used to define a criterion in the form of a logical expression can be used to intervene in all the on-line tables, the constants and the functions. Only the lines for which the condition evaluation returns a result that is not null (i.e. true) are involved in the data extraction. |
| It defines the table key code used to read the linked lines. By default, the first key of the table is used. |
|   |
|   |
|   |
Creation rule
| This field can take two values :
|
| When the synchronization rule is of the type (1,N), this field from the principal table is used, which is supposed to be dimensioned (several occurrences). The extraction algorithm is thus used to access the data in the grids stored in the principal on-line table. The principle is as follows : there is the possibility to vary the system variable index from 0 to N-1, N being the dimension of the triggering field and for each value :
|
| This condition is defined in the form of a calculation formula. It is evaluated on each iteration carried out on the number of occurrences of the triggering field (the variable index varying from 0 to N-1, N being the dimension of the triggering field). Other than the variable index, it can reference the fields in the on-line tables, as well as the constants, the global variables, the function defined by the programmer (syntax func PROGRAMME.FONCTION). If the result of the evaluation is not null, the update is triggered. |
Grid Links
| It identifies the table linked to the table of origin. |
| It corresponds to the abbreviation under which the linked table is open. If this field is not populated, the default abbreviation of the table is used. It is particularly useful to enter an abbreviation if the table appears several times in the grid, since several linked lines in the same table need to be on line simultaneously. |
| It defines the table key code used to read the linked lines. By default, the first key of the table is used. |
|   |
| This field is defined as one or more calculated expressions separated by a semi colon. Each expression is evaluated, and the result used to identify the value of the key used to perform the join. When multiple joins are authorized, only the first elements of the key can be given. In the expressions, constants can be used, as well as fields coming from the tables previously defined in the link list. It should be noted that the link expression can be empty. In this case, the table is simply on-line without the current records being read. This can be useful if for example a function defined by a developer (syntax func PROGRAMME.FONCTION) is used. This function can be used to read the information in tables of this type. |
Grid Folders
| The folders are defined here from which the data will be copied. The possible syntaxes are described in the dedicated appendix. From the time of the copy, the variable GDOSSIER gives the folder code from which the data is extracted. |
Close
Presentation
This screen is used to define the fact table to update and the values associated to each field of this table in the form of formulae that can require the intervention of all the on line data, global variables, constants as well as functions defined by the user. If the creation rule is of 1,N type, the intervention of the index variable can also be required in the formulae.
Fields
The following fields are present on this tab :
Block number 1
|   |
|   |
|   |
|   |
|   |
The following fields are included on the window opened through this button : Block number 1
Block number 2
Close This button is used to copy the record definition from or to another folder. |
This menu item allows access to the documentation management on the first paragraph of the documentation (if there is one) associated with the current record.
This menu item allows access to link management. It is used to define the links between the current record and other records (for example, the links between functions and parameters). These links are specific to the documentation and are used to load the generation of documentation structures.
This menu item launches a documentation generation. You can also launch it from the Generation button at the bottom of the screen.
You can launch three types of generation one by one or simultaneously
The range suggested by default takes into account the current record, but you can modify it at launch time.