Essbase - Dealing with Missing Fields in a Data Source during data load

Essbase Overview

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.

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.





Discover More
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...



Share this page:
Follow us:
Task Runner