Execute Consolidation Task

Data Manager packages allow you to manage data within SAP Business Planning and Consolidation models and dimensions.

Context

Data Manager packages are implemented as process chains and allow common data manipulation activities. The packages that come with SAP Business Planning and Consolidation are designed to be dynamic so you do not need to modify the packages for them to work with your models and dimensions.

The Financial packages that can be used for the consolidation process, apart from the Standard and Administrative packages, are in the following table:

Process Chain Template	Description	Technical Name
Planning and Consolidation Default Formulas Logical	Executes default formulas stored in your default.xls file.	/CPMB/DEFAULT_FORMULAS
Planning and Consolidation FX Restatement	Allows you to perform currency translation. The package runs the FXTrans logic.	/CPMB/FX_RESTATMENT
Planning and Consolidation IC Elimination	Allows you to perform intercompany eliminations. The package runs the ICElim logic.	/CPMB/IC_ELIMINATION
Planning and Consolidation: ICBooking	Runs the ICBooking logic.	/CPMB/ICBOOKING
Planning and Consolidation ICData	Runs the ICData logic.	/CPMB/ICDATA
Planning and Consolidation Legal Consolidation	Runs the LegalConsolidation logic.	/CPMB/LEGAL_CONSOLIDATION
Planning and Consolidation Opening Balances	Runs the OpeningBalances logic.	/CPMB/OPENING_BALANCES
Planning and Consolidation Run CalcAccount	Runs the CalcAccount logic.	/CPMB/RUNCALCACCOUNT
Planning and Consolidation Clear the Journal Tables	Clears journal tables and creates an output file.	/CPMB/CLEAR_JOURNALS
Planning and Consolidation Export the Journal Tables	Exports journal tables to an output file	/CPMB/EXPORT_JOURNAL
Planning and Consolidation Restore Journal Tables	Allows you to load journal tables from a file	/CPMB/RESTORE_JOURNALS

Procedure

Add the Data Manager packages for a consolidation model:

For more information, see the application help for SAP BusinessObjects Analysis, edition for Microsoft Office available on the SAP Help Portal.
Create Script Logic files (LGF).
Script Logic allows users to define formulas that perform calculations on SAP Business Planning and Consolidation members and data.

You can create the following different types of logic:
- Dimension Member Formulas;
- Script logic.
Each type has advantages and disadvantages. Logic is model-specific and all script logic statements are case-insensitive.
1. In the navigation panel, go to Administration and under the Rules section choose Logic Scripts.
2. Select Scripts for CONSOLIDATION and click Open.
3. Click New.
4. Create an LGF file by using the script logic supported by SAP Business Planning and Consolidation.
  
  Note
  
  The Logic File name must be identical to the string defined with the data package.

Maintain the business rule table.

SAP Business Planning and Consolidation delivers predefined functions designed to calculate and post amounts required to support common accounting activities such as:

Currency translation
Matching and elimination of inter-unit balances.

To allow a customer the flexibility to customize these functions to meet specific requirements table-based logic is used.

For each predefined function, there are one or more Business Rule tables, in which the business user can configure rules such as:

What balances should be read in order to calculate an amount to be posted.
What are the posting rules for the calculated amount (meaning, to what account and data source is the calculated amount posted).

Table-based logic (Business Rules) provides the flexibility for a customer to customize delivered functions (logic), to meet specific business needs, without having to understand either scripting or programming.

The following Business Rule (table-based logic) functions are delivered with SAP Business Planning and Consolidation:

Currency Translation	Convert local currency data into the desired reporting currencies
Account-based Calculations	Calculate and store amounts, which are required for purposes of account-based calculations
Intercompany Bookings	Match intercompany transactions
US Eliminations	US eliminations Specifically designed to address the posting of intercompany eliminations in simpler scenarios where a full legal consolidation model is not required.
Carry-Forward	Initialize the opening balances when a new fiscal cycle starts
Eliminations and adjustments	Generate all the consolidation entries for the desired groups of entities (such as eliminations, adjustments, reclassifications, and minority calculations)

The procedure to maintain the business rules is as follows:

In the navigation panel, go to Administration and under the Rules section choose Business Rules.
Select the CONSOLIDATION Model and click Add/Remove Rule Types in the toolbar.
In the Add/Remove Rule Types dialog box, select the rule types you require and click OK.
Click the business rule type under the CONSOLIDATION model in the table grid.

Alternately, select the row of the business rule and click Open in the toolbar.
In the Business Rule Editor, click New to create a new rule, or select an existing rule and click Edit in the toolbar to modify the content of an existing rule according to business requirements.