When you calculate formulas, be sure to use parentheses correctly.
In the following example, incorrectly placed parentheses causes Essbase to perform two calculation passes through the database: once calculating the formulas on the members Qtr1 and Qtr2; and once calculating the formula on Qtr3:
(Qtr1; Qtr2;) Qtr3;
In contrast, the following configurations cause Essbase to cycle through the database only once, calculating the formulas on the members Qtr1, Qtr2, and Qtr3:
Qtr1; Qtr2; Qtr3;
(Qtr1; Qtr2; Qtr3;)
Similarly, the following formulas cause Essbase to cycle through the database once, calculating both formulas in one pass:
Profit = (Sales - COGS) * 1.5; Market = East + West;