Selecting Source Data Items for a Dimension

You can select data items from any of the configured data sources to later map to your dimension fields.

The source data items shown in the Select source data items dialog box are retrieved from the saved schema. You can use the Get schema option in the data source editor (Connection tab) to refresh the data source schema. For more information, see Configuring the Connection Information for Data Sources.

To select source data items for a dimension

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, click the Fields () button. The Fields editor appears.

4. Click the Data Source Item Picker () button. The Data Source Item Picker dialog box appears.

   

   The Data Source items pane shows the available schema of the data sources.

5. Click the Expand icon to expand the data source and view the source data items within the data source.

   NOTE: You can use the Find box to search a source data item. The search behaves as a 'Contain' query.

6. Select a source data item from which you want to expose the fields to add the data source item. Deselect a source data item to move an item back to the Data Source items pane.

   The names in a data source table should not contain the special character, semicolon (;). The names that contain special characters like semicolon (;) and (#) do not appear in data source items pane.

   The bottom grid of the dialog box shows the fields of the source data item that you select in the Data Source items pane. The first source (from the top of the list) providing a value for the field will be used in the resulting dimension table.

7. Slide to enable the Preview source data option to view sample data from the data source.

8. Click OK.

   Selected data source items become available for mapping to the dimension fields.

   For more information, see Mapping Dimension Fields to Data Item Fields.