Consolidation Rules

Consolidation is the process of gathering data from child entities and aggregating the data to parent entities. When you run a consolidation, each child’s contribution to the parent is derived by using the default application calculations, and the results are written to the Entity Currency member of the parent. You can use the default or write your own consolidation rules. The power of being able to write your own rules is that you can control what accounts move from the Parent total to the Proportion and Elimination members of the Value dimension.

The best place to start with writing your own consolidation rules is to use the rules provided in the Sample Applications folder. This folder is found on the server where the install took place. When you select the “Y” option in the application settings, you will need to add a subroutine like that provided, as shown in Figure B-24.