About Consolidation jobs
A Consolidation job does the following:
Converts currency from the source currency to the reporting (destination) currency by using the Currency Conversion model.
Eliminates holding company investments and subsidiary equity.
Eliminates intercompany balances and transactions.
Uses the specified consolidation rule templates to complete calculations, for example, the minority interest calculation.
A consolidation job performs these tasks by running a set of business rules. For more information, see Consolidation rules.
To run a job, you must not only have permission to run the job, but also Read permission on the Planning Server system database. Otherwise, you cannot see the results of the job. If you do not currently have Read permission on the database, talk to the Planning Server data administrator.
Templates and properties
If you selected the Consolidation template for this job, you must set the following properties to run the job:
| Job property name | Description |
|---|---|
ConsolidationModelID |
Model on which to run the selected consolidation. |
GroupParentEntityLabel |
The parent entity for which the Consolidation job will run. |
ConsolidationScenarioLabel |
The scenario for which the Consolidation job will run. |
CurrencyLabel |
The currency type to which the parent entity will be consolidated. |
ConsolidationStartPeriodLabel |
The first period for which the Consolidation job will run. |
ConsolidationEndPeriodLabel |
The last period for which the Consolidation job will run. |
ExchangeRatesStartPeriodLabel |
The start date to use for exchange rates in the currency conversion that is completed as part of the consolidation process. |
ExchangeRatesEndPeriodLabel |
The end date to use for exchange rates in the currency conversion that is completed as part of the consolidation process. |
ExchangeRatesScenarioLabel |
The scenario to use for exchange rates in the currency conversion that is completed as part of the consolidation process. |