Several types of data can be returned to a worksheet view:
Numeric data values
#NoAccess strings, which are displayed when you cannot access a data value
#Missing strings, which indicate that no data exists for that member intersection
A missing value is not the same as a zero value that is loaded into the Essbase database. When data does not exist for a data cell in Essbase, a value of #Missing is returned to the worksheet. (If a cell in a row contains a value, that row is not suppressed on a retrieval.)
Zero data values
Using Essbase, you can suppress the display of missing and zero values in the worksheet, and underscore characters contained in member names.
To suppress the display of rows containing missing values, zeros, or underscore characters in the worksheet:
The #Missing Rows and Zero Rows options are not available when you select an option in the Formula Preservation group on the Mode page.
After you enable the #Missing Rows or Zero Rows suppress option, missing values or zero rows suppressed during a data retrieval are not retrieved again by disabling the feature. If you disable these features in the Essbase Options dialog box, missing values or zero rows are retrieved only from that point on. To return these missing values to the worksheet, disable the Missing Rows or Zero Rows suppress option, drill up on the member, and drill back in.
When applying the option for suppressing Underscore Characters to member names containing a mixture of spaces and underscores, when you retrieve a second time upon clearing the suppress Underscore Characters option, Essbase cannot retrieve the member names behavior because Essbase expects to find member names containing all spaces or all underscore characters.