Return to Financial Consolidation Model Overview.
The purpose of filters is to limit the execution of consolidation rules. A consolidation rule is only executed if all filter criteria are met. Any filter that does not match the criteria will prevent the execution of the consolidation rule.
The consolidation rule engine supports two sorts of filters: Regular filters and Additional filters for the intercompany parties applied to the pair of entities.
Regular filters
Version
The version filter is used to restrict a consolidation rule to specific versions. It is a regular expression pattern that needs to match the element in the Version dimension to meet the filter criteria. The default value is .*, meaning any number of characters.
Suppose different versions use different charts of accounts (e.g., a shortened version with much aggregated values vs. a pretty fine-grained one). In that case, the consolidation rules can also be set up to reflect these differences. For example, one consolidation rule could apply only to the actual version (e.g., using the ^Actual$ regex) whereas another one applies only to forecast versions (e.g., using the ^Forecast regex to match elements starting with Forecast). Another use case would be versions that support different reporting standards.
Month Valid From and Month Valid To
The month validity filter denotes an alphanumeric range for the elements of the Month_YTD dimension. Note that the base elements of this dimension look like 2019-12_YTD when the model is set up for a regular calendar year or look like FY2019-12_YTD when the model is set up for the periods of a particular fiscal year. By default, the Month Valid … filters are set up from 1900-01_YTD (representing "since ever") to 2999-12_YTD (representing "forever"). For a fiscal year setup, these would be from FY1900-01_YTD to FY2999-12_YTD.
This can be used to reflect changes in the chart of accounts over time. So an old variant of a consolidation rule could be used from 1900-01_YTD to 2020-05_YTD (meaning every period until May 2020), and the new version could be used from 2020-06_YTD to 2999-12_YTD (meaning every period after June 2020).
Consolidation Method
Consolidation rules can be activated for any of the consolidation methods:
F - Full Consolidation
P - Proportional Consolidation
E - Equity Consolidation
N - Not Consolidated
Precisely, the filter criteria are checking on the combined consolidation method of both parties:
| Consolidation Method of the partner entity | ||||
| Consolidation Method of the legal entity | F | P | E | N |
| F - Full Consolidation | F | P | E | N |
| P - Proportional Consolidation | P | P | E | N |
| E - Equity Consolidation | E | E | E | N |
| N - Not Consolidated | N | N | N | N |
Ledger
Consolidation rules can be activated for either one or for both ledgers:
-
Consolidation ledger
-
Segment Consolidation ledger
Note that some consolidation functions are invalid in all ledgers.
Additional Filters for the intercompany parties
Some consolidation functions offer data for every entity in the group and require one additional filter from this group to limit the execution to the intended pair of entities. These functions required one of the filters in this group.
See Combinations of Entities for more details on this topic.
Direct Ownership Rate
When activated, this filter processes a consolidation rule only if the legal entity has a direct ownership rate within the specified range. A variant of this filter checks if the partner entity has a direct ownership rate on the legal entity within the specified range.
Consolidation Rate
When activated, this filter processes a consolidation rule only if the legal entity is the holding and the partner entity has a consolidation rate within the specified range. A variant of this filter checks, if the partner entity is the holding and the legal entity has a consolidation rate within the specified range.
Updated November 4, 2024