Selecting the Skip Option

If you set a time balance as first, last, or average, you must set a skip property to tell Essbase what to do when it encounters missing values or values of 0.

  To select a skip option:

  1. Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.

  2. Select the accounts dimension.

  3. Select the Account Info tab.

  4. Locate the Skip group.

  5. Select a Skip option:

    • None—Does not skip data when calculating the parent value. This property is the default value. If, however, Essbase encounters #MISSING data when calculating an average, it does not divide by the total number of members. It divides by the number of members with actual values. Therefore, setting the skip property to none or #MISSING does not affect average (but does affect first and last).

    • Missing—Skips #MISSING data when calculating the parent value.

    • Zero—Skips data that equals zero when calculating the parent value.

    • Missing and Zero—Skips #MISSING data and data that equals zero when calculating the parent value.

  6. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.