Select a consolidation method to determine how children members will roll up into their parents during calculations.
For information on consolidation options, see Consolidation of Children Members Overview.
To select a consolidation method:
Access the member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.
Select the Info tab.
Select a Consolidation method:
+ [addition]—Adds the member to the result of calculations performed on other members. This operator is the default operator if no other valid value is found.
- [subtraction]—Multiplies the member by -1 and then adds the result to the sum of calculations performed on other members.
* [multiplication]—Multiplies the member by the result of calculations performed on other members.
/ [division]—Divides the member by the result of previous calculations performed on other members.
% [percent]—Divides the member by the sum of previous calculations performed on other members and multiplies the result by 100 to yield a percentage value.
~ [ignore]—Does not use the member in the consolidation to its parent.
^ [never]—Never uses the member for any consolidation.
External source—In the drop-down list, select a column from the database where the consolidation operator is stored. The consolidation value (+, -, *, /, %, ~) of the selected column of the data source is used for consolidation.
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.
Note:
To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.