Member consolidation operators determine how children roll up into their parents. By default, new members are given the addition (+) operator, meaning that Essbase adds the members. For example, Essbase adds January, February, and March figures and stores the result in their parent, Qtr1.
Important: When working with an aggregate storage outline, the following consolidation property guidelines apply:
For the dimension tagged as accounts, all consolidation operators can be used.
For all other dimensions, only the (+) consolidation operator can be used.
Additionally, if the Label Only property is being used for members in a dimension, the direct child of the lowest Label Only member can have any consolidation operator; however, all indirect children of the lowest Label Only member must be tagged with the (+) consolidation property.
Notes:
When working with aggregate storage outlines, use care when selecting a database column from the External source consolidation option. When performing loads, Essbase Studio Server may not recognize the consolidation operators that are stored in the database column. The server will not notify you of the potential for errors during validation.
Note: | For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide. |
For members of the Accounts dimension, the From Database Column drop-down list box is not displayed when the Accounts dimension was created from the fact table.