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 |