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 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.


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.

Powered by ComboStrap