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 / XX / 0 |
#MISSING#MISSING#MISSING |
X % #MISSING#MISSING % XX % 0 |
#MISSING#MISSING#MISSING |
X == #MISSING
|
False, unless X is #MISSING |
X != #MISSINGX <> #MISSING
|
True, unless X is #MISSINGTrue, 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 |