If no data value exists for a unique combination of members, Hyperion Essbase gives the
combination a value of #MISSING
. A #MISSING
value is different
from a zero (0) value. Therefore, Hyperion Essbase treats #MISSING
values differently from 0 values.
The following tables shows how Hyperion 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 / XX / 0 |
#MISSING #MISSING #MISSING |
X % #MISSING #MISSING % XX % 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 * 0 OR #MISSING #MISSING OR #MISSING
|
1 #MISSING #MISSING |
IF (#MISSING )
|
IF (0) |
f (#MISSING )
|
#MISSING for any Hyperion Essbase function of one variable |
f (X) | #MISSING for any X not in the domain of f, and any Hyperion Essbase function of more than one variable (except where specifically noted) |
* 1 represents any nonzero value.
For information on how Hyperion Essbase aggregates #MISSING
values, see the Database Administrator's Guide.
Copyright 1991-2002 Hyperion Solutions Corporation. All rights reserved.