Building and Executing the Sales Information View
To obtain product sales information, you use the ds_orders data source and the transformation productCatelog_xform.
• The orders data source contains order details in the orderdetails table.
• The transformation productCatelog_xform contains product catalog information.
To build and execute the sales information view
1. Right-click Shared > sources in the resource tree.
2. Create a new view named ViewSales.
3. From the ds_orders data source, drag the orderdetails table into the Model panel.
4. Drag the productCatelog_xform into the Model panel.
5. Click OK on the empty window that pops up.
6. Join productid in orderdetails with ProductID in productCatelog_xform.
The join between two different types of resources, one derived from a relational table, and the other from an XML data source.
7. In the Grid panel, limit the query to the following columns:
productCatelog_xform.*
orderdetails.status
orderdetails.discount
8. Save the view.
9. Execute the view.
10. In the result set displayed in the Result panel, locate one of the three rows where ProductID = 23 with the following data:
ProductID: 23
These results contain information about the product name, the lead time for product delivery, and other data relevant for the current example.
11. Close the ViewSales tab.
After adding the data sources to the TDV metadata environment, you created three views as follows:
— View 1 to obtain order information for the Order department.
By executing this view, you were able to view the activities of the order department at ALPHA. You learned about the product status, order date, and customer contact information.
— View 2 to obtain supplier information for the Purchase department.
By executing this view, you were able to learn about ALPHA’s purchase department’s interactions with the customer and the supplier.
— View 3 to obtain sales information for the Sales department.
By executing this view, you were able to use the sales department’s record and noted the lead time for product delivery.
You will query these views and create a single unified view representing the solution for the customer-reported issue at ALPHA.
