what will user see for Q1?

Assuming you have a Period dimension with calendar months rolling to quarters to total years. If
you assign the property Time Balance Last to the “Headcount” account member, what will user
see for Q1?

A.
January’s value

B.
March’s value

C.
The total of January+February +March

D.
The average of January + February + March

Explanation:
Set the time balance as “last” when you want the parent value to represent the value
of the last member in the branch (often at the end of a time period).
Note:
Essbase – Time balance properties
The tags :
first,
last,
average,
and expense
are available exclusively for use with accounts dimension members.
Using this tag requires an accounts dimension and a time dimension
If an accounts dimension member uses the time balance property, it affects how Essbase
calculates the parent of that member in the time dimension. By default, a parent in the time
dimension is calculated based on the consolidation and formulas of its children. For example, in
the database in this scenarion, the Q1 member is the sum of its children (Jan, Feb, and Mar).
However, setting a time balance property causes parents, for example Q1, to roll up differently.
If you set the time balance as first, last, or average, set the skip property to tell Essbase what to do
when it encounters missing values or values of 0.