Placing Formulas on Time and Accounts Dimensions

If you place a member formula on a time or accounts dimension, it may be overwritten by a time balance calculation.

Table 79 shows an example in which Opening Inventory is tagged as First:

Table 79. Example of the Effects of (TB) First

Measures -> Year

Jan

Feb

Mar

Qtr1

Opening Inventory: First

30000

28000

27000

30000

Because Opening Inventory is tagged as First, Essbase calculates Opening Inventory for Qtr1 by taking the Opening Inventory for Jan value. Any member formula that is placed on Qtr1 in the database outline is overwritten by this time balance calculation.