Skip to content

Matrix filter properties

List of matrix filters

Element Description
Complementary This allows the user to exclude a specific filter or node from a node of filters in a hierarchy. Thus, the system displays the entire hierarchy of the filter’s parent node or excluded node, except for the specific filter or node. Note: the additional filter is identified by the prefix and works on hierarchies but not groupings.
Comparison condition It allows the user to define a condition for comparison, or an operator and a value with which to compare the filter value. To specify an individual element of the filter to be compared, use the operator "=". To exclude one of them, use the operator "<>". For example: with operator "=" and value “INPUT_DEFORM" on an Origin type filter, the user can obtain the sum of all the figures with origin "INPUT_DEFORM”.
Reference FX rates This allows the user to define a different FX rate from that which is specified in the table, i.e. whether it needs to be read from a scenario or period other than those of the data to be converted. See Details of Reference FX rate properties.
FX rate Allows the user to view the entity or transaction amounts in a different currency. See Details of FX rate properties.
Periodic value calculation Allows the user to specify the calculation method for the periodic value. The calculation methods vary depending on the reporting engine used (see Form options window).
Size Indicates the dimension to which the selected element belongs. Non-editable property.
Navigation Only visible if a parametric filter on the Scenario dimension has been selected. Allows the user to set criteria for navigating between scenarios (previous, next and reference). For more details, see Navigating scenario parameters.
Period Difference Only visible if a parametric filter on the Period dimension has been selected. Allows the user to set criteria for navigating between periods. For more details, see Navigating period parameters.