Matrix consolidation key points
In the corporate close process, we have run the intercompany elimination tasks and now we can report on the results. We need reports that show the performance from a management perspective as well as from a legal perspective. For example, legal reports will be by consolidation unit but management reports will be by profit center or segment.
In addition, we have a business requirement to view income statement data with a consolidation view as compared to a contribution view:
- The consolidation view will show total revenue by entity along with an elimination entity (for each consolidation unit hierarchy node).
- The contribution view will show revenue net of eliminations by entity.
In the Consolidation unit consolidation and contribution view example, we are reporting on consolidation unit revenue with the contribution view and the consolidation view. The same hierarchy is being used for both views. The consolidation view dynamically determines the elimination entity based on the first common parent in the legal hierarchy.
Each view uses a different dimension:
- Contribution view uses the Consolidation Unit dimension.
- Consolidation view uses the Consolidation Unit for Elimination dimension.