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.

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)

Documentation / Reference


Powered by ComboStrap