Elements of the transactional forms model
Characteristics of transactional form columns¶
The following elements can be specified for transactional form columns:
- Attributes, which supplement the column's definition with information on the format, the type of values that it can contain and potentially a table of those values. They facilitate data entry because they can generate drop-down menus in column cells to choose the value for the cell on which you are working.
- Exceptions to the column's mandatory nature and editability for specific accounts
- Dictionary on any column of the transactional form, once the dictionary type is defined, the same dictionary is selected in the form column relationship. Thus, it is possible to create columns that are not linked to CCH Tagetik dimensions only.
- Filters: indicate if a filter on the data related to the column must be set in the form's data entry step and what type the filter must be. The filter can be obligatory or optional, as a single choice (where only one value can be entered) or multiple choice (where one or several values can be entered).
Specific information on the default values of columns¶
A text-type default value or formula-type default value can be assigned to the column. Text-type values must be inserted manually. Formula-type values can be numeric or the results of SQL queries.
| Value type | Description |
|---|---|
| Numeric | The formula determines the value shown in the form column. The formula can contain numeric constants, the four operations (+ - * /), round brackets and reference to a Field name (see Transactional form columns page). |
| SQL queries | The formula that determines the value shown in the column is an SQL-type query and allows you to indicate a value depending on the value of one or more fields of the form or a table in the CCH Tagetik database. Formulas with SQL queries have the following particular features: - Reference to a column of the form must be specified in braces. {COD_DEST1} indicates the value of the "Custom dimension 1" column of the row being inserted. - References to several numeric fields must indicate the relationship between the fields. IMPORTO_1*IMPORTO_2/IMPORTO_3. |
When the form is run, the cells show the results of the formula.
Exceptions for columns with accounts¶
When columns are set up in the transactional forms information model, data entry rule (optional or mandatory) is defined, or the column can be made available in read only mode. A formula written in SQL language can be inserted on the column. The formula should be defined on the Default value/Formula field. When the form is run, the formula is not shown as an Excel formula but is calculated directly on the server.
If the column does not contain data related to CCH Tagetik dimensions, it is possible to insert Exceptions in insertion for account. This field indicates whether mandatoriness or editability exceptions are in place for the column, based on the account (see Attributes tab).
Dictionaries¶
A dictionary can be associated with any text-type or amount-type column; this allows the user, in the data entry step, to search for and select a value from a drop-down menu. This menu lists the dimension elements or dataset fields present on the column.
Example
In the presence of a column for control groups and another column for accounts, it is possible to create a single query-type dictionary in which the query returns the following results:
- the code and description of the control group
- the code and description of the accounts belonging to the control group
These results must then be associated with the two columns.
In data entry, the system proposes the list of possible control groups on the first column and the list of accounts belonging to that control group on the second column. For this to take place, once the query-type dictionary has been defined, it is necessary to specify which fields of the query correspond to the code and which correspond to the description using two free attributes: Query code field for the code and Query description field for the description.