Dealing with Missing Fields in a Data Source

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 Placing Text in Empty Fields.

Note:

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.

If a rules file has extra blank fields, join the empty fields with the field next to them. See Joining Fields.

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.