Create or Modify a Consolidation Model

A model is either a planning model or a consolidation model. After completing relevant Business Warehouse back-end settings, you can create and define a consolidation model in the Business Planning and Consolidation web client.

Within the same environment, multiple consolidation models may exist, each one pointing to its own consolidation, rate, and ownership InfoProviders. Multiple consolidation models can share the same consolidation or rate or ownership InfoProviders, if appropriate.

To create a consolidation model, you must map BW InfoProviders to a CONSOLIDATION InfoProvider and an OWNERSHIP InfoProvider. You have the option to map BW InfoProviders to an EXCHANGE RATE InfoProvider and a SOURCE InfoProvider. Then, you need to map InfoProvider dimensions to dimension types required by the SAP Business Planning and Consolidation consolidation engine, as well as map InfoObject attributes to dimension properties required by the consolidation engine.

1. In the navigation panel, go to Administration  Modeling  Models.

2. Select the consolidation model you want to maintain or create a new consolidation type model.

3. Select the corresponding InfoProviders for the CONSOLIDATION InfoProvider and the OWNERSHIP InfoProvider and, if needed, select corresponding InfoProviders for the EXCHANGE RATE InfoProvider or SOURCE InfoProvider.

4. Click Go to Mapping/Review Mapping to navigate to the dimension mapping view for one of the InfoProviders (CONSOLIDATION, OWNERSHIP, EXCHANGE RATE, or SOURCE) you want to change.

5. Choose an aggregation level for the InfoProvider.

6. Map the InfoObjects to related dimension types.

7. Click Go to Mapping/Review Mapping for each dimension to navigate to the dimension property (attribute) mapping view.

   You will be able to see all the pre-delivered dimension attributes that may be useful in a consolidation scenario. The attributes with a red asterisk are mandatory. You can use the dropdown box on the right side to map an existing dimension (InfoObject) attribute to the dimension properties required by consolidation engine.

8. Navigate to Create New Model  Advanced Settings, then select superior compounding members for each dimension member. For Account and Time type dimension members, fixed superior compounding dimension members must be specified. For others, this value is optional. Once a fixed superior compounding member is selected, you cannot select other superior compounding members in consolidation calculations.

9. After finish all the settings, click Save and Validate to finish creating the Consolidation model.