Calculating Members with Different Operators

When siblings have different operators, Essbase calculates the data in top-down order. Consider the following members:

Parent1
  Member1 (+)  10
  Member2 (+)  20
  Member3 (-)  25
  Member4 (*)  40
  Member5 (%)  50
  Member6 (/)  60
  Member7 (~)  70

Essbase calculates Member1 through Member4 as follows:

(((Member1 + Member2) + (-1)Member3) * Member4) = X
(((10 + 20) + (-25)) * 40) = 200

If the result of this calculation is X, Member5 consolidates as follows:

(X/Member5) * 100 = Y
(200/50) * 100 = 400

If the result of the Member1 through Member4 calculation is Y, Member6 consolidates as follows:

Y/Member6 = Z
400/60 = 66.67

Because Member7 is set to No Consolidation(~), Essbase ignores Member7 in the consolidation.