1. Administrator's Guide
  2. Managing Metadata
  3. Defining Consolidation Methods
  4. Assigning Consolidation Methods Manually

Assigning Consolidation Methods Manually

To enter consolidation method information manually, you can create a data grid with this information:

POV: Scenario, Year, Period, View, Entity, Value, Account, Custom
Scenario: Applicable scenario
Year: Applicable year
Period: Applicable period
Entity: A parent entity 
Value: [None]
Account: [Method] system-generated account
Custom: ToCurrency
Row: ICP entities. For parent entities, you use the ICP Entities system list, or a user-defined list of selected ICP entities.
Column: FromCurrency. You should use the ConsolMethods system-generated list.

Method assignment information is stored in the account method of the data file of the parent entity. For each child of a parent, the system stores the consolidation method assignment in the ICP dimension. The assigned method is used when the children are consolidated to the parent.

For an intersection of the grid, use 1 to indicate the method assignment to the ICP entity. For example, if a parent group has two children, A and B, and you assign the Global method to A and the Equity method to B, enter 1 in the intersection for the Global method and entity A and 1 in the intersection for the Equity method and entity B.