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.