Setting Member Consolidation Properties

Essbase determines the value of a parent by accumulating the values of its children. Consolidation operators defined for each child member define how Essbase treats each value; for example, whether to add or subtract a value. By default, new members are given the addition (+) operator, meaning that members are added. For example, in the Sample Basic database, Jan, Feb, and Mar values are added and the result is stored in their parent, Qtr1.

Note:

In aggregate storage outlines, there are some restrictions on the use of consolidation operators. For more information about the differences between aggregate and block storage, see the Oracle Essbase Database Administrator's Guide.

  To set the consolidation property for a member in an outline:

  1. Open the outline in edit mode.

  2. Select the member, right-click, and select Edit member properties.

  3. In the Member Properties dialog box, select the Information tab.

  4. In the Consolidation drop-down list, select the consolidation operator.

  5. Click OK.

Related Information