Setting Skip Properties

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

SettingEssbase Action

None

Does not skip data when calculating the parent value.

Missing

Skips #MISSING data when calculating the parent value.

Zeros

Skips data that equals zero when calculating the parent value.

Missing and Zeros

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