Selecting a 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 member properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Member Properties Tabs.

  2. Select the Accounts dimension.

  3. Select the member.

  4. Select the Account Info tab.

  5. Locate the Skip group.

  6. Select a Skip option:

    • None—The default value. Does not skip data when calculating the parent 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.

    • External source—In the drop-down list, select the column in the database that contains the desired skip option.

      Note:

      For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide.

  7. 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.