Skip to content

Types of parameter

Multi-hierarchy parameter

When a parameter is defined on a hierarchy, the user must specify the hierarchy in question. When the form is opened, it will only be possible to choose values belonging to that hierarchy. In certain types of configuration, it may be necessary to define multi-hierarchy parameters. These parameters are defined on a dimension which, when the form is opened, allows you to choose a hierarchy from among all those belonging to the dimension. Multi-hierarchy parameters can only be defined on the Entity and Target dimensions.

Multi-hierarchy parameters cannot be used within filters (form, tab, matrix, row, column) defined as OR clauses. When the multi-hierarchy parameter is used, it is not possible to select several elements belonging to different hierarchies as OR items.

If a multi-hierarchy parameter is created with a hierarchy that is already being used in the same position (rows, column, matrix filter), the system does not allow the form to be run.

When the form is run, to obtain the hierarchy to which the chosen dimension element belongs, the syntax @MHP_PARAM.Dimension.HierarchyCode, where MHP_PARAM is the code of the defined multi-hierarchy parameter, can be used in cell fields or in elements that allow advanced selection.

If you decide to use multi-hierarchy parameters on the rows/columns of a matrix, for the description and/or code to be displayed in the headers correctly, the parameter syntax must be added to the headers configured in the Matrix Wizard. For example, with a multi-hierarchy parameter on the Entity dimension, the syntax to use to obtain the description is $Entity(false).desc.

Process parameter

The process parameter allows you to view the list of processes included in the table.

It cannot be used in Reporting forms, but it can be used by DTP modules, QDL and Jobs. The following properties can be configured:

  • code and description in the Properties tab
  • the Only show active processes parameter in the Restrictions tab, which limits the display to the table’s active processes available for data entry

Note: Process parameters are not shown in the dimensions tree for defining form, tab and matrix filters, because they are not supported.

Dictionary parameter

The dictionary items available for the parameter depend on the dictionary associated with the form.

Dictionary parameters are associated with a transactional dictionary defined on the Financial layer, or an analytical dictionary belonging to an Analytical Information Hub workspace.

In the parameters definition window, after selecting the type "dictionary", you will be able to select its source by choosing whether to use a Financial Layer dictionary or a dictionary from a specific Analytical Workspace.

When Financial Workspace is selected, the system loads all the transactional dictionaries whereas when an Analytical Workspace is selected, the user can choose a dictionary from among all those belonging to the selected workspace.

Dictionary parameters cannot be defined in the following cases:

  • The selected dictionary parameter uses an analytical dictionary belonging to a workspace with no dataset.
  • The selected dictionary parameter uses an analytical dictionary defined using an SQL query containing dimensional attributes.

The running of the analytical dictionary query is not affected by user restrictions on dimensions.