For a data load rules file to validate, all of the following questions must be answered “yes.”
Is the rules file associated with the correct outline?
See “Validating Rules Files” in the Oracle Essbase Administration Services Online Help.
Does each record in the data source contain only one member from each dimension?
Are all members surrounded by quotation marks if they contain numbers or file delimiters?
See Valid Member Fields.
Is the member that each data field maps to spelled correctly in the rules file?
See Changing Field Names.
Are the file delimiters correctly placed?
See Valid Delimiters.
Is the member in the field name a valid member?
See Mapping Fields.
Is the dimension name used in only one field (for example, not in a field name and the header)?
You can map a single data value to only one set of members.
Is the UDA used for sign flipping in the associated outline?
See Flipping Field Signs.