Calculating #MISSING Values


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 / 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*
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.