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
Correct Answer: B
Explanation/Reference:
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.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
