Setting Member Consolidation
Member consolidation properties, which are listed in Table 16, Consolidation Operators, determine how children roll up into their parents. By default, new members are given the addition (+) operator, meaning that members are added. For example, Jan, Feb, and Mar figures are added and the result stored in their parent, Qtr1.
Table 16. Consolidation Operators
Operator | Description |
---|
+ | Adds the member to the result of previous calculations performed on other members. + is the default operator. |
- | Multiplies the member by –1 and adds it to the sum of previous calculations performed on other members. |
* | Multiplies the member by the result of previous calculations performed on other members. |
/ | Divides the member into the result of previous calculations performed on other members. |
% | Divides the member into the sum of previous calculations performed on other members. The result is multiplied by 100 to yield a percentage value. |
~ | Does not use the member in the consolidation to its parent. |
^ | Does not use the member in any consolidation in any dimension. |
To set member consolidation properties, see “Setting Member Consolidation Properties” in the Oracle Essbase Administration Services Online Help.