You can choose how Essbase consolidates members by applying any calculation operator (+, -, /, *, %, ~, ^) to the members in the database outline.
If an accounts member has a time balance tag (First, Last, or Average), Essbase consolidates it accordingly. See Calculating First, Last, and Average Values.
If a parent member has a label only operator, Essbase does not calculate the parent from its children.
If a member has a ~ operator, Essbase does not consolidate the member up to its parent.
If a member has a ^ operator, Essbase does not consolidate the member in any dimension.
If you use dynamic calculations, Essbase may use a different calculation order. See Calculation Order for Dynamic Calculation. |