Tab filter properties table
Description¶
This table shows certain properties, the number and type of which depend on the selected filter or filters. The name and value are shown for every property. The properties needed for standard tab filter functionality are defined with a default value. Properties which refer to the same aspect of the setup and represent the details thereof are grouped below a main item identified with the 
icon.
If several filters are selected at the same time, the table will only show the shared properties and it will be possible to define the same property for all the selected filters with a single action.
Reference FX rates
| Element | Description |
|---|---|
| average | Average FX rate of the period in which it is calculated. These are the FX rates generally used for P&L accounts. |
| period average | Applies a different FX rate for every period into which the year is divided. Allows the user to perform more accurate conversions than the average FX rate. |
| final | Period-end FX rates. These are used for the balance sheet accounts, with the exception of the equity accounts, which are typically converted at the historical FX rate. |
| based on account | FX rate used for conversions and defined in the accounts table |
Sign change
Account dimension properties. When active, this inverts the sign of the data.
Complementary
When active, this excludes a filter or node from the node of filters containing it. The value shown is the total value of the parent node excluding the filter or node on which the property is active
Size
Not editable. Indicates the dimension to which the selected element belongs.
Advanced selection
| Element | Description |
|---|---|
| Detail subtotal | Displays the subtotal for every dimension nested in the filter node. In the presence of three or more nested dimensions, activate the option to prevent potential style application errors. |
| Generate subtotals up to | Allows the user to define the starting node for calculating subtotals. - Root: generates subtotals based on the hierarchy root (default value). - Starting node: generates subtotals based on the selected intermediate node. Note: this has no effect if the elements returned as the result of the Advanced Selection script do not belong to the starting node’s sub-tree. See Details of advanced selection scripts for calculating the default value. |
| Restrictions | The system allows you to insert in the table restrictions on dimensions of the sheet, primarily between entity/custom dimensions, in order to allow, in data entry, data to be read/written only on the relative custom dimensions specified in the table, to improve performance. This option allows you to override these restrictions on dynamic elements, in order to see the data without the restrictions set in the table. Hierarchy Node Intersection: by default, if a single dimension of the matrix has several hierarchies, the system presents the intersection of the two hierarchies, i.e. the data related to elements belonging to both hierarchies. By activating this option, the system shows all combinations of elements of both hierarchies. See Entity elements. |
| Pruning | Hides empty rows/columns. - Not valued: hides from the table rows/columns which are found to have no data in the database during the run form phase. The value zero is considered as data. - To zero: hides from the table rows/columns which are found to have no data in the database during the run form phase or have the value 0 entered. - None: shows all rows/columns. |
| Script | Allows the user to set a query on CCH Tagetik’s application database in the cell using a TGKML syntax, see Advanced selection script. |
| Subtotals | Only with dynamic filters. When the form is run, at every hierarchy level interruption, it displays the subtotal calculated on the lowest level elements. The subtotal therefore takes the name of the parent node of the lowest level elements on which the subtotal is calculated (for example: Europe is the name, and therefore the parent node, of the subtotal calculated on the lowest level elements Italy, France, Spain etc.). For more details on the general settings for subtotals, see Matrix options tab. |
| Selection type | Define which hierarchy levels to display. - None - Insert all children: only displays the child nodes of the selected filter. - Insert lowest level elements: displays all the lowest level elements present below the selected node, to the last level. - Insert Parent: displays the parent node of the selected filter. - Advanced selection: activates the Script property. Allows the user to insert dynamic elements that cannot be inserted via standard selection. - Insert analytical FST : (with Account type elements inserted via items of an FST) allows the user to define an analytical FST in which both the FST items and the related accounts are displayed. For more details, see Financial statement templates. - Insert synthetic FST: (with Account type elements inserted via items of an FST) allows the user to define a synthetic FST in which only the FST items are displayed. For more details, see Financial statement templates. - Control group: (with Account type elements entered via control groups) allows the user to define the accounts with reference to a group. |
Dictionary
| Element | Description |
|---|---|
| Allows the user to select an existing dictionary item. See Dictionary Items window. |
Formula
| Element | Description |
|---|---|
| Opens a window to write the calculation formula. | |
| Prevailing | Makes the formula the prevailing formula in case of intersection with others. |
| Calculation logic type | - Client: the formula refers to dimension elements contained in the tab filter and is solved in the local client. - Server: the formula refers to elements of the dimensions present in other sheets or other elements of the form, the formula is solved on the server and the client receives the resulting value. |
Hide
| Element | Description |
|---|---|
| Never | In this case, the sheet is displayed when the form is run. |
| Always | In this case, the sheet is hidden when the form is run. |
Segment
Properties of the entity and accounts dimension
| Element | Description |
|---|---|
| (from configuration) | Reads and applies the values indicated in the application’s general settings to the Default section of the Form tab. See Settings window. |
| None | Does not apply any filters to journals |
| Per Segment parent | The value shown includes all consolidation journals (IC eliminations, financial investment eliminations, other corrections) for all nodes or legal entities belonging to the same "parent" node. |
| By segment | The value shown includes all consolidation journals (IC eliminations, financial investment eliminations, other corrections) between legal entities belonging to the same node. |
| Intersegment | Identifies the values relative to all journals referring to legal entities belonging to different segments. This function is activated ONLY if the selected node has at least TWO levels below it. Data can be read according to this method both when creating "Tab filters" and when selecting "Prompt Filter", respecting all the restrictions on the depth of the levels for the choice of "Intersegment". |
| Per Intersegment Parent | Identifies the values relative to all journals referring to legal entities belonging to different segments and, starting from a level below, takes all the journals that start from the node on which the function is activated. |
Navigation
Only for parametric filters on the scenario dimension. See Navigating scenario parameters.
| Element | Description |
|---|---|
| Previous | Selects the scenario indicated in the scenarios list as the previous scenario to the selected scenario. See Navigating scenario parameters. |
| Next | Selects the scenario indicated in the scenarios list as the next scenario following the selected scenario. See Navigating scenario parameters. |
| Reference | Selects the scenario indicated in the scenarios list as the selected scenario’s reference scenario. See Navigating scenario parameters. |
Period Difference
Only for parametric filters on the period dimension.
Allows the user to navigate periods, shifting forwards or backwards from the period selected when the form is run.