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.
Table 15 describes how each setting determines what Essbase does when it encounters a missing or zero value.
Table 15. Skip Properties
Setting | Essbase Action |
---|---|
Skips data that equals zero when calculating the parent value. | |
Skips #MISSING data and data that equals zero when calculating the parent value. |
If you mark a member as last with a skip property of missing or missing and zeros, the parent of that time period matches the last nonmissing child. In the following example, EndingInventory is based on the value for Feb, because Mar does not have a value.
Cola, East, Actual, Jan, EndingInventory (Last), 60 Cola, East, Actual, Feb, EndingInventory (Last), 70 Cola, East, Actual, Mar, EndingInventory (Last), #MI Cola, East, Actual, Qtr1, EndingInventory (Last), 70