Time Balance Properties

Note the two tags in the Measures dimension of Table 9—TB first and TB last. These tags, called time balance tags or properties, provide instructions to Essbase about how to calculate the data in a dimension tagged as accounts. Using the tags requires a dimension tagged as accounts and a dimension tagged as time. The first, last, average, and expense tags are available exclusively for use with accounts dimension members.

In the TBC Measures dimension, Opening Inventory data represents the inventory that TBC carries at the beginning of each month. The quarterly value for Opening Inventory equals the Opening value for the quarter. Opening Inventory requires the time balance tag, TB first.

Ending Inventory data represents the inventory that TBC carries at the end of each month. The quarterly value for Ending Inventory equals the ending value for the quarter. Ending Inventory requires the time balance tag, TB last. Table 8 defines the time balance tags for the accounts dimension.

Table 8. Accounts Member Tags

Tags

Description

Time Balance Last

The value for the last child member is carried to the parent. For example, March is carried to Qtr1.

Time Balance First

The value for the first child is carried to the parent. For example, Jan is carried to Qtr1.

In Table 9, Qtr1 (second column from the right) and Year (right-most column) show how consolidation in the time dimension is affected by time balance properties in the accounts dimension. Data is shown for the first quarter only.

Table 9. TBC Consolidations Affected by Time Balance Properties

Dimensions

Jan

Feb

Mar

Qtr1

Year

Accounts Member1

11

12

13

36

Qtr1 + Qtr2 + Qtr3 + Qtr4

Accounts Member2 (TB First)

20

25

21

20

20

Accounts Member3 (TB Last)

25

21

30

30

Value of Qtr4

Normally, the calculation of a parent in the time dimension is based on the consolidation and formulas of children of the parent. However, if a member in an accounts branch is marked as TB First, any parent in the time dimension matches the member marked as TB First.

For examples, see Setting Time Balance Properties.