Return to Financial Consolidation Model Overview.
The Consolidation Function Dimension (used internally) defines possible calculation functions for consolidation rules. This dimension is not configurable.
The attributes which have “.Enabled“ form define the visibility of the according parameter fields on the "Consolidation Rule Line" report.
In case the attribute is 1, as soon as the according consolidation function is selected, the field is displayed. In the case of 0, the field is hidden.
The Consolidation Function elements can be configured through their attributes:
| Attribute | Description |
| Name | Readable name of the account. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string) |
| Description | Long text description of the account. This attribute can contain a definition of the amounts booked to the account or instructions for the planners. Localized translations can be provided. (string) |
| ID_Name | Technical element name of the article as well as the readable name. If localized translations are provided Name attribute, this attribute will also become localized. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string, calculated) |
| Number of line details per line |
Defines the number of line details per line |
| Factor.Enabled |
Define the visibility of the Factor parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Factor is selected, the field is displayed. In the case of 0, the field is hidden. |
| Rate 1.Enabled |
Define the visibility of the Rate 1 parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Rate 1 is selected, the field is displayed. In the case of 0, the field is hidden. |
| Rate 2.Enabled |
Define the visibility of the Rate 2 parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Rate 2 is selected, the field is displayed. In the case of 0, the field is hidden. |
| Business Transaction Type.Enabled |
Define the visibility of the Business Transaction Type parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Business Transaction Type is selected, the field is displayed. In the case of 0, the field is hidden. |
| Account.Dimension |
Which account dimension the rule is applied to, e.g., BS Account or PnL Account dimension |
| Account.Operator.Enabled |
Define the visibility of the Account.Operator parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Account.Operator is selected, the field is displayed. In the case of 0, the field is hidden. |
| Account.Mode.Enabled |
Define the visibility of the Account.Mode parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Account.Mode is selected, the field is displayed. In the case of 0, the field is hidden. |
| Transaction Type.Enabled |
Define the visibility of the Transaction Type parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Transaction Type is selected, the field is displayed. In the case of 0, the field is hidden. |
| Transaction Type.Operator.Enabled |
Define the visibility of the Transaction Type.Operator parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Transaction Type.Operator is selected, the field is displayed. In the case of 0, the field is hidden. |
| Transaction Type.Mode.Enabled |
Define the visibility of the Transaction Type.Mode parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Transaction Type.Mode is selected, the field is displayed. In the case of 0, the field is hidden. |
| Consolidation.Enabled |
Define the visibility of the Consolidation parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Consolidation is selected, the field is displayed. In the case of 0, the field is hidden. |
| Calculation.Enabled |
Define the visibility of the Calculation parameter fields on the "Consolidation Rule Line" report. In case the attribute is 1, as soon as the Calculation is selected, the field is displayed. In the case of 0, the field is hidden. |
| Pattern | Pattern to build the Intercompany Account elements for the consoldiation |
| Intercompany Matching Pattern | Pattern to build the Intercompany Account elements for the intercopmany matching |
| Intercompany Matching Pattern | Pattern to build the Intercompany Account elements for the intercopmany matching with inverted I/C relation |
| Consolidation Ledger | Consolidation function is supported in the Intercompany cube |
| Segment Consolidation Ledger | Consolidation function is supported in the Intercompany (Segment) cube |
| Additional Filter Required | One of the additional filters DO, DOX, CRT, CRTX is required |
Updated August 25, 2023