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.