Matrix filter properties table
Introduction¶
The properties table allows the user to manage the filter properties to customise the matrix. When several filters are selected, only the shared properties are shown and the values set on them will be applied to all the selected filters.
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 |
FX rate
Currency dimension properties.
| Element | Description |
|---|---|
| For matrices on the financial layer | |
| From Configuration | Value, displayed in brackets next to the active property, previously configured in Default FX rate for the new filters on the currency in the Forms section of CCH Tagetik’s general settings. See Currencies: basic concepts. |
| None | The Currency dimension is used as a dimension filter: only records whose currency is the selected currency will be read by the database. |
| Final FX rate | The records read by the database are converted into the selected currency using the final FX rate, as defined in the FX rate table. |
| Average FX rate | The records read by the database are converted into the selected currency using the average FX rate, as defined in the FX rate table. |
| Period average FX rate | The records read by the database are converted into the selected currency using the period average FX rate, as defined in the FX rate table. The FX rate property of the Currency dimension, as well as the equivalent property in Reference FX rates, does not support the Period average FX rate option if the form uses the standard reporting engine. Where this configuration is used, at the run form step, this option is automatically set to Based on account. A warning is sent and the user must correct the form configuration. |
| Based on account | In the accounts table, it is possible to define the FX rate to be used in the various data processing to covert the relevant amounts (Conversion property, with the following possible values: None, Final, Average or Period average). With this setting, the form converts records read from the database into the selected currency, using the relative FX rate, as defined in the table, for each of them. |
| For matrices on the analytics layer | |
| None | The Currency dimension is used as a dimension filter: only records whose currency is the selected currency will be read by the database. |
| Based on the measure | The option to be applied is read from the numerical measure configuration in which it is possible to define the desired FX rate for that measure from the web interface. (See Dataset fields). |
| Based on account | With this setting, the form converts records read from the database into the selected currency, using the relative FX rate, as defined in the table, for each of them. If the account dimension is not present in the dataset, the Based on the measure FX rate is applied. |
Particular features of conversion based on account¶
Conversion based on account is only applicable when the dataset has the account dimension. If the “based on account” conversion type is specified and the matrix does not have the account dimension, the form is not run. If the account has a conversion type that is not supported by the analytical matrices, i.e. it is not the average FX rate, period average FX rate or final FX rate, the Based on the measure FX rate type is applied.
Forms in which global filters (form filters or sheet filters) on the currency are used will have the following behaviours:
| When... | Then... |
|---|---|
| the dataset does not contain the account dimension | if the matrix has no overrides on the currency dimension, the system considers the currency indicated in the global filter: - if the conversion type is final, average, or period average, the system applies the Based on the measure conversion type. - if the conversion type is None, then no filter is applied and only the values in the selected currency are read. |
| of the matrix specifies an override on the Currency dimension, then the global filters are not applied. | |
| the dataset contains the Account dimension | the Based on Account conversion type is applied, regardless of what is specified at the matrix level, save for matrix overrides. |
Periodic value calculation
Period length dimension properties.
| Element | Description |
|---|---|
| Automatic | The properties’ behaviour varies based on the engine used for reporting. Default value. See Types of reporting engine. Note: option used when the Period length is not specified in any of the form’s filters. |
| Aggregation of periodic values | Calculates the cumulated data as the sum of periodic figures. For example, the quarterly figure for the second quarter is calculated as the sum of the monthly figures read from periods 4, 5 and 6. |
| Net Year-to-date values | Calculates the cumulated data as the net year-to-date values. For example, the quarterly figure for the second quarter is calculated as the difference between the year to date figure for period 6 and the year to date figure for period 3. |
Size
Specifies the dimension and group/hierarchy from which the filter has been taken. Not editable.
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.