Assigning Consolidation Methods Manually

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

POV: Scenario, Year, Period, View, Entity, Value, Account, C2, C3, C4

Scenario: Applicable scenario

Year: Applicable year

Period: Applicable period

Entity: A parent entity

Value: [None]

Account: [Method], a system generated account called Method

C2 [None]

C3: [None]

C4: [None]

Row: ICP entities (For parent entities, you can use the [ICP Entities] system list or the user-defined list of selected ICP entities.)

Column: Custom1 (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.