Essbase - #MI or #MISSING

Essbase Overview

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





Discover More
Essbase Data Source Kinds Of Fields
Essbase - Data fields

Data fields are a component of data source which contain also : , Either the data source or the rules file must contain enough information for Essbase to determine where to put each data value....
Essbase Overview
Essbase - Data load in a parent member overwritten by consolidation

If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite...
Essbase Overview
Essbase - Dealing with Missing Fields in a Data Source during data load

Each record in the data source must have the same number of data value fields to perform a data load. If data values are missing, the data load processes incorrectly. For example, the following file is...
Essbase Dimension Build Rules Files
Essbase - Dimension build rules files

When you create dimension with thousands of member or with many alternate hierarchy, you want to automate the process to add the member. You use Dimension build rules files to map dimension and member...
Essbase Data Source Kinds Of Fields
Essbase - Essbase-friendly/free-form Data Sources (Don't Need a Rules File during data load)

If a contains all of the information required to load the data values in it into the database, you can load the data source directly in afree-form data load (without rule file) To load a data value successfully,...



Share this page:
Follow us:
Task Runner