Data-load rules files specify how data-source fields are mapped to database members.
Data Prep Editor provides mapping methods for non-duplicate and duplicate members. Duplicate members can be specified by level (if data-source fields that are organized bottom-up) or by generation (if data-source fields that are organized top-down).
To map data source fields to database members:
Select the field.
Select Field, then Properties.
In the Field Properties dialog box, select the Data Load Properties tab.
In Field, enter the target member or member combination, or select the members in the Dimension node. If you enter a substitution variable name, the substitution variable value that is set at the time the data load is performed is used.
To specify a unique member name, in the Field name text box under the Default option, enter the target member or member combination, or select the member in the Dimension node.
If the Dimension node is empty, click the Outline button to associate the rules file with an outline.
To map to a duplicate member name, select Use reference method, specify the generation or level number as applicable, and specify the dimension.
Click OK.