The information that you specify in the Data Load Properties tab is used, during data loads, to map data-source fields directly to members or member combinations of the Essbase database.
Note: | When data load rules are applied to SQL data sources, field names default to table field names, and, thus, SQL and Essbase database names may not match. In this case, you can map using Essbase names. |
For outlines that contain only unique member names, select the Default option. Then, in the Field name box, enter a member name or a member combination (separated by commas), or, in the Dimension node, double-click a dimension or member. The current field is mapped to the specified member, member combination, or dimension.
For outlines that contains duplicate member names, select the Use reference method option, and enter the following information:
Type—Double-click Generation or Level.
Reference number—Enter the generation or level number. The default is the generation or level number of the previous field.
Reference dimension—Enter a dimension name, or, in the Dimension node, double-click a dimension or member.
Note: | If the Dimension node is not populated, click the Outline button, and associate the rules file with an outline. |
Select one or more of the following options, each of which applies to the current field:
Data field—Select this option if the data source contains a field for each dimension and one data column.
Date field—After you select this option, you can select a date format.
Ignore field—Select this option if you do not want to load the field into the outline.
Scale—Select this option to apply a multiplier (which you specify) to the field values. For example, assume that a Sales data source tracks values in hundreds and that the Essbase database to which data is being loaded tracks real values. In this case, you must multiply the data-source values (such as 54.6) by 100 (to load and display in the Essbase database such as $5460).