Essbase - #MI or #MISSING
About
MI or #MISSING represent missing or unknown values.
If a data source contains blank fields for data values, replace them with #MI or #MISSING.
If there is no value in the data field (or the value is #MISSING), Essbase does not change the existing data value in the database. Essbase does not replace current values with empty values.
Articles Related
ASO/BSO syntax
In ASO, the syntax is a little different than in BSO. You must write for
- BSO:'#MISSING;'
- ASO: 'MISSING'
In ASO, you would just have the word MISSING without the # sign or the semi-colon.
Calculation
| Calculation | Result |
|---|---|
| X + #MISSING | X |
| X – #MISSING | X |
| #MISSING – X | -X |
| X * #MISSING | #MISSING |
| X / #MISSING | #MISSING |
| #MISSING / X | #MISSING |
| X / 0 | #MISSING |
| X % #MISSING | #MISSING |
| #MISSING % X | #MISSING |
| X % 0 | #MISSING |
| X == #MISSING | False, unless X is #MISSING |
| X != #MISSING | True, unless X is #MISSING |
| X <> #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) |
| 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) |