Mapping Dimension Fields to Fields from a Single Source Data Item

You can map dimension fields to source data item fields from a single source data item.

To map dimension fields to fields from single source data item

1. Open the BI Gateway Model Builder.

2. Under the Dimensions column, click the dimension to which you want to add a dimension field.

3. In the Dimension editor in the right pane, click the Fields () button. The Fields editor appears.

   The Field name column shows the name of the dimension fields.

   The Field type column shows the data type of the corresponding dimension fields.

   For more information on Managing Dimension Fields, see Managing Dimension Fields.

   The column to the right of Field Type shows the source data item that you have selected for the dimension.

   For more information, see Selecting Source Data Items for a Dimension.

4. Under the source data item column, select the source data item fields to map to the corresponding dimension fields.

   You can provide a constant value in the source data item field. After check in the system verifies whether the dimension field type is compatible with the constant type.

   You can map a dimension key field that is part of a composite key to a "Null" or constant value only if at least one of the key fields of the composite key is mapped to a source data item field. You cannot map a dimension key field that is part of a composite key to "Skip".

5. Click Save.