Review the members required to run the consolidation process. 

The key members include:

  • Dataview: The provisioned system should already have an All Dataviews hierarchy with a Consolidation member. The best practice is to have the results of the consolidation calculation stored in the Consolidation Dataview member. Use the #AllDataView tag to define the parent member of Value, Conversion, Calculation, and Consolidation DataView members.
  • Entity: Most consolidation adjustments are recorded in Elimination entities when consolidating in Non-Group dimension tenant (typically preferred in North America) and directly in Entities when consolidating in Group dimension dimension tenant (typically preferred in Europe). Elimination entities must be created for each parent entity in a Non-Group tenant consolidation. They shouldn't be created for a consolidation in a Group tenant. For example, the USA member contains a child called USA Elimination.