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 tables shows how Essbase calculates #MISSING values. In this table, X represents any number.
| Calculation/Operation | Result |
|---|---|
| X + #MISSING | X |
X – #MISSING #MISSING – X | X -X |
| X * #MISSING | #MISSING |
X / #MISSING #MISSING / X X / 0 | #MISSING #MISSING #MISSING |
X % #MISSING #MISSING % X X % 0 | #MISSING #MISSING #MISSING |
| X == #MISSING | False, unless X is #MISSING |
X != #MISSING X <> #MISSING | True, unless X is #MISSING True, unless X is #MISSING |
| (X <= #MISSING) | (X <=0) |
| (X >= #MISSING) | (X >=0) or (X == #MISSING) |
| (X > #MISSING) | (X > 0) |
| (X < #MISSING) | (X < 0) |
X AND #MISSING: 1 AND #MISSING* 0 AND #MISSING #MISSING AND #MISSING | #MISSING 0 #MISSING |
X OR #MISSING: 1 OR #MISSING[1] 0 OR #MISSING #MISSING OR #MISSING | 1 #MISSING #MISSING |
| IF (#MISSING) | IF (0) |
| f (#MISSING) | #MISSING for any Essbase function of one variable |
| f (X) | #MISSING for any X not in the domain of f, and any Essbase function of more than one variable (except where specifically noted) |
For information on how Essbase aggregates #MISSING values, see the Oracle Essbase Database Administrator's Guide.