Databases Reference
In-Depth Information
Next, we'll join our analytic view with our attribute view so that we can see the customer name
(from the attribute view) alongside their order information (from the analytic view). To do this,
we need to switch to the
Logical View
tab.
To join the attribute view to the
Data Foundation
tab of the analytic view, simply click on the
junction field in the attribute view, and drag it to the junction field in the
Data Foundation
tab.
We'll join using the
CUST_ID
field in the attribute view, and the
CUST_ID_1
field in the
Data
Foundation
tab of the analytic view, as shown in the following screenshot:
That's all that needs to be done; our analytic view has been created, and it joins the
ORDERS
table
to the attribute view (which we created on the
CUSTOMERS
table). We're almost done—once the
analytic view has been activated, we'll be able to see our data, so do that now. Activation of an
analytic view is done in the same way as an attribute view; just click on the green save and activate
button at the top right-hand corner of the analytic view development pane.
Step 5 - Previewing the data
The
Data Preview
function that we saw earlier is a more useful function when used to visualize
the output of an analytic view.
Open the
Data Preview
tab for our analytic view; you will see the order information, from the
ORDERS
table, alongside the customer name, from the
CUSTOMERS
table: