Operation Results on #MISSING Values and Zero (0) Values


If a data value does not exist for a unique combination of members, Analytic Services gives the combination a value of #MISSING. A #MISSING value is different from a zero (0) value. Therefore, Analytic Services treats #MISSING values differently from 0 values.

The following tables shows how Analytic Services 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 Analytic Services function of one variable
f (X) #MISSING for any X not in the domain of f, and any Analytic Services function of more than one variable (except where specifically noted)

* 1 represents any nonzero value.

For information on how Analytic Services aggregates #MISSING values, see the Database Administrator's Guide.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com