If a dimension or member field is missing, Essbase uses the value that it used previously for that dimension or member field. If there is no previous value, Essbase aborts the data load.
For example, when you load the following file into the Sample.Basic database, Essbase maps the Ohio member field into the Market dimension for all records, including the records that have Root Beer and Diet Cola in the Product dimension.
Jan Sales Actual Ohio Cola 25 "Root Beer" 50 "Diet Cola" 19
Essbase stops the data load if no prior record contains a value for the missing member field. For example, if you try to load the following file into the Sample.Basic database, the data load stops, because the Market dimension (Ohio, in the previous example) is not specified.
Jan Sales Actual Cola 25 "Root Beer" 50 "Diet Cola" 19
For information on restarting the load, see Loading Dimension Build and Data Load Error Logs.