Database Reference
In-Depth Information
The External Data-Data Mapping dialog box should look like Figure 6.8.
Figure 6.8
External Data-Data Mapping dialog box
9.
Click
Next
to display the
Data Attributes
pane.
This pane would allow you to change some of the basic attributes of the data items in the
external data source. Since the order numbers are numeric in the data warehouse and we
will not be aggregating the numbers, we will not change any of the settings in the Data
Attributes window.
The External Data-Data Attributes dialog box should look similar to Figure 6.9.
10.
Click
Next
to display the
Mapping Options
pane.
11.
Under the
Existing query subject items section:
(right side of the dialog window),
select the
Some values exist more than once
radio button.
There may be more than one order detail record for the orders we are selecting. Your
External Data-Mapping Options dialog box should look like the one in Figure 6.10.
12.
Click
Finish
.
The Manage External Data dialog box is now visible with the
Orders
external data
source included.
13.
Click
Publish
.