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 dimension reference) that Essbase uses to map the field.
Level and generation references: The data source contains multiple fields within the duplicate member dimension to uniquely identify duplicate members.
Use the level reference method when fields within a dimension are organized bottom-up in the data source.
Use the generation reference method when fields within a dimension are organized top-down in the data source. For example:
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
Dimension reference: If an outline contains a duplicate member name in different dimensions—for example, a member name such as Other can be meaningful in different dimensions—you can use the dimension reference method. When you set a field to use the dimension reference method, you also identify the dimension to which members in that field belong. When the dimension reference method is specified for a field, Essbase checks to ensure that members in the field belong to the dimension specified for the field.