Characteristics of the Entity dimension in consolidation processes
Consolidations performed on a financial model with shares calculations are sometimes referred to as Statutory Consolidations, or consolidation with shares. To perform consolidation with shares, the modeler must create an Entity dimension structure that has a special, two-level hierarchy. This structure has a single parent entity, typically the holding company. All other entities are first-level children of this parent. This structure is required to perform the calculations that compute ultimate percent of ownership correctly.
For information about how to create this structure, see How do I set up a model for shares calculation and consolidation?
Note
Entities that are not included in the hierarchy will not appear in the cube. You will not be able to enter data for these entities.
The consolidation process eliminates data for all entities that are in the hierarchy but do not have shares information. That is, the process does not include data from these entities in the consolidated results.
Staged consolidations for multi-level hierarchies
If you want to run consolidation with shares, but your business situation requires an entity hierarchy that has more than two levels, you can perform Staged Consolidation. Planning Business Modeler supports staged consolidations by using multiple models. If you use separate models, you can run a separate Shares Calculation job for each parent at each level. Then, you can move consolidated data from each stage by using a process such as model association to run a Data Movement job.
For information about this, see How do I create an association to move data between models?