Examples
Consolidations are done in the same way for variables as they are done for success measure for the time dimension and across units.
Units
If you use Sum, ensure that you clear data from all parent cells. To get correct results for Sum, your table should have empty data cells like the following table. It shows what would appear if the unit consolidation method for Unit 1 is Sum or None:
| Unit | Entered | What appears if you select sum | What appears if you select none |
|---|---|---|---|
| Unit 1 | 10 | ||
| Region 1 | 6 | ||
| Area 1 | 2 | 2 | 2 |
| Area 2 | 4 | 4 | 4 |
| Region 2 | 4 | ||
| Area 3 | 1 | 1 | 1 |
| Area 4 | 3 | 3 | 3 |
For the Unit dimension, if you have data in parent cells (similar to Region 1 and Region 2 do in the succeeding table) and select Sum as your consolidation method, that data is included in the consolidation, which can cause incorrect results, which can look similar to this:
| Unit | Entered | What appears if you select sum | What appears if you select none |
|---|---|---|---|
| Unit 1 | 27 | ||
| Region 1 | 7 | 13 | 7 |
| Area 1 | 2 | 2 | 2 |
| Area 2 | 4 | 4 | 4 |
| Region 2 | 10 | 14 | 10 |
| Area 3 | 1 | 1 | 1 |
| Area 4 | 3 | 3 | 3 |
Plan objects
Strategy Management does not do any consolidation of outcome and activity for variables as is done for the success measure. Consider the case where both a plan object itself and its children have a value for a certain variable (materials or sales). This table shows the results:
| Plan Object | Entered | What appears if you select sum | What appears if you select none |
|---|---|---|---|
| Objective 1 | 10 | ||
| Strategy 1 | 7 | 6 | 7 |
| Tactic 1 | 2 | 2 | 2 |
| Tactic 2 | 4 | 4 | 4 |
| Strategy 2 | 10 | 4 | 10 |
| Tactic 3 | 1 | 1 | 1 |
| Tactic 4 | 3 | 3 | 3 |