To select a skip option:
Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.
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.
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.