Considering the Effects of First, Last, and Average Tags

Table 78 shows how Essbase consolidates the time dimension based on the time balance (TB) First, Last, and Average tags on accounts dimension members.

Table 78. Example of the Effects of (TB) First, Last and Average

Accounts -> Time

Jan

Feb

Mar

Qtr1

 

Accounts Member1

11

12

13

36

Value of Jan + Feb + Mar

Accounts Member2 (TB First)

20

25

21

20

Value of Jan

Accounts Member3 (TB Last)

25

21

30

30

Value of Mar

Accounts Member4 (TB Average)

20

30

28

26

Average of Jan, Feb, Mar