Data Load Rules file is the second type of rules files which is involved in the data load process.
A data source for data load must contain :
In addition to mapping metadata in data source to your dimension, rules files enable you to transform data upon loading in the following way :
To create a data load rules file:
You must map each rules file field to the corresponding outline member, or as a data field or ignored field. Other field characteristics may also apply.
For duplicate member outlines, you must specify the method (level reference, generation reference, or parent-child reference) that Essbase uses to map the field.
gen2,Market, gen3,Market, Product, Year, Measures, Scenario, *data*
State,"New York","100-10",Jan,Sales,Actual,42
City,"New York","100-20",Jan,Sales Actual,82
State,Texas,"100-10",Jan,Sales,Actual,37
For a data load rules file to validate, all of the following questions must be answered “yes.”
You can map a single data value to only one set of members.