If a data value does not exist for a unique combination of members, Essbase gives the combination a value of #MISSING. A #MISSING value is different from a zero (0) value. Therefore, Essbase treats #MISSING values differently from 0 values.
The following link shows how Essbase calculates #MISSING values.
http://docs.oracle.com/cd/E12825_01/epm.111/esb_techref/frameset.htm?launch.htm
The following link shows how Essbase calculates #MISSING values.
http://docs.oracle.com/cd/E12825_01/epm.111/esb_techref/frameset.htm?launch.htm