About Consolidation jobs in Planning Business Modeler

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 PerformancePoint 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

Desc ription

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.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×