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.

Note:

Essbase does not use consolidation properties with members of attribute dimensions. See Calculating Attribute Data.

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.