About
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 invalid, because there is no value under Apr:
Actual Ohio Sales Cola
Jan Feb Mar Apr
10 15 20
To fix the file, insert #MISSING or #MI into the missing field:
Actual Ohio Sales Cola
Jan Feb Mar Apr
10 15 20 #MI
See Replacing an Empty Field with Text.
Articles Related
Behaviour
When a dimension field or member field is missing
If a dimension field or member field is missing, Essbase uses the value that it used previously for that dimension or member field. See Missing Dimension or Member Fields.
When a Rules file has extra blank fields
If a rules file has extra blank fields, join the empty fields with the field next to them. See Joining Fields.
of MISSING in an aggregate storage databases
In aggregate storage databases, values can be loaded only to level 0 cells. Specifying #MISSING or #MI as a value in the data source removes the associated cell if it is present in the database. For information about data load differences for aggregate storage databases, see Preparing Aggregate Storage Databases.