Effect of Position and Operator on Consolidation
Essbase calculates the data of a branch in top-down order. For example, if you have, in order, two members tagged with an addition (+) operator and a third member tagged with a multiplication (*) operator, Essbase adds the first two and multiplies that sum by the third.
Because Essbase always begins with the top member when it consolidates, the order and the labels of the members is important. See Calculating Members with Different Operators.
Table 7 defines Essbase consolidation operators.
Table 7. Consolidation Operators
Consolidation Operator | Description |
---|
Plus sign (+) | The default operator. Essbase adds the member to the result of previous calculations performed on members of the branch. |
Dash (–) | Essbase multiplies the member by ‑1 and then adds the product to the result of previous calculations performed on members of the branch. |
Asterisk (*) | Essbase multiplies the member by the result of previous calculations performed on members of the branch. |
Forward slash (/) | Essbase divides the member into the result of previous calculations performed on members of the branch. |
Percent sign (%) | Essbase divides the member into the sum of previous calculations performed on members of the branch. The result is multiplied by 100. |
Tilda (~) | Essbase does not use the value of the member in the consolidation to its parent. |
Caret (^) | Essbase never uses the value of the member in any consolidation in any dimension. |